Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Any tips for securing an Access database

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Any tips for securing an Access database

Resolved · Low Priority · Version 2003

Reply Mon 13 Jun 2011, 10:18Delegate Mark said...

Mark has attended:
Access Advanced course

Any tips for securing an Access database

I'm looking for tips on securing an Access database using Windows logon. I don't want users to have to remember another password.

For upcoming training course dates see: Pricing & availability

Reply Wed 22 Jun 2011, 14:00Trainer Stephen said...

RE: Any tips for securing an Access database

Hi mark

Thanks for your question

I suggest splitting the database into a backend and a frontend, using the database splitter. Each person would then access the database through their own copy of the frontend, which would only be available after they had loged on. The forms in each frontend could be tailored to the user thus allowing

1. Control over what each user can see
2. Control over what records/fields could be edited/deleted
3. Limits on what design changes can be carried out

Hope this is useful

Regards

Stephen

Tue 28 Jun 2011: Automatically marked as resolved.

Access articles

· Up The Professionalism Of Access Files Thanks To Digital Signatures
· How much time could you save with Access?
· What You Need To Know About New Security Features In Access 2007
· How To Use The Analyze Table Tool In Access
· Discover Decisive Details In Your Data, With Access 2010

Please browse our web site to find out more about
microsoft access training uk and other Microsoft training courses.

Access tip:

Deleting duplicate records from a table

You cannot delete records tables where there duplicate records. A way around this is to create a new table which wont hold the duplicates. and then deleting the old table.

1. Use a make-table query based on this table only. IMPORTANT - Ensure that you include all of the fields from your original table or you may loose data.

2. Open the query's property sheet by using VIEW, QUERY, PROPERTIES, and set the Unique Values property to Yes

3. Because you have selected the Unique Values to Yes when you run the query, Access creates a new table without duplicate records. You can now delete the old table and rename the new one.

View all Access hints and tips