Attached is an application written in Access 2010 that provides an alternative to ULS in later versions of Access. It can be bolted onto any existing database by just copying all of the objects and pasting them into your system.. Then just change the start up form to be the password dialog box.
It includes the following features:
- Password Protected Login
- User Level Security (Depending on your specified security levels)
- User Management Console (For adding/editing/removing users/resetting forgotten passwords etc.)
- First time login function for using generic passwords when setting up new users. (will prompt user to change their password on first use)
It will require some knowledge of VBA and Access to integrate this into an existing application but should be straight forward enough to learn from.
Credit must be paid to Richard Rensel@Quantum Data Solutions for the original idea of this back in 2002. All I've done is rebuild it, freshen the look and feel of the UI and update the code for Access 2007-2010.
Any questions drop me a line
Zip File Contents:
Security Levels 2012 Signed.accdc (Digitally Signed Package (Due to trust centre settings on some machines))
Security Levels Template 2012.accdt (Template File to create your database from)
Security Levels 2012b.accdb (Raw Database file - *Most people will just use this.)