How do you secure your DB in '07? I just built a DB that needs to have some type of user authentication to gain access. I would like to set the username as their email address and have the user set their own password upon first time login.
As the administrator and I need to have full access to everything in the db. I need each user to have their own username and password and only have access to the forms.
I am fairly new to Access and need detailed instructions. Is there a good step-by-step guide to set this up? The only info I could find was for Access 2003.
Please help!
Thanks!!!