access+courses+in+london - Lock a form

Resolved · Low Priority · Version Standard

Wed 10 Jan 2007, 11:45 Delegate Amy said...

Amy has attended:
Access Advanced course

Lock a form

I've set a main form which opens by default when users enter the database but I would like to know how you lock a form so that users can't access the database behind it? & also how you unlock it after you've done this.

Thanks

Amy

Wed 10 Jan 2007, 15:16 Trainer David said...

RE: Lock a form

Hi Amy

Yes you are able to lock database tables. If you go to tools and then options in the menu bar at the top of Microsoft Access a options window will open. The areas that will be of interest to you are view tab, this will enable you to remove the screen where you can select the tables you want to see. The other tabs that will be useful for you are the Advanced table and the tables/queries. Within these tabs you will be able to lock down the database tables and set permissions that the uses have.

Hope this helps

David

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

Related tables

When you have related tables such as Customers and their Orders, the Customer table is the Primary table.

Open the Customers table in datasheet view and go to the Home Tab and Records group. Click on the More option and choose Subdatasheet and then click on Subdatasheet again. Now choose the related table (Orders) and click ok.

Now you can click the + symbol by each company to show the related orders.

View all Access hints and tips