Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Access Training and help » Any tips for securing an Access database
Resolved · Low Priority · Version 2003
Mark has attended:
Access Advanced course
I'm looking for tips on securing an Access database using Windows logon. I don't want users to have to remember another password.
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 tip:Relationship mapsIt is important to create proper relationships between tables. You can use Access to help check your designs and evaluate them by printing them in graphical format to help with design purposes |
We'll call during UK business hours
Server loaded in 0.08 secs.