Login Form on Access open

[BartK]

Hi everyone,
I have access 2010, I currently have a database in place and operational. What I am wondering is there a way to have a form come up whenever someone opens access and asks for a password and login name. Also I would like to have a 2 tier system. One for Admins and the other for users with limited access.

Is this even possible to accomplish? Any advice would be helpful. Thanks

 

[Isskint]

First create a User table. Include a 'Settings' or 'security' field.
Then create an unbound Log In form to collect the username and password.
If the details are valid (use a LogIn command button to check) you can;
1, open any form
2, open a form based on the users settings field.

You can then also add a check to each forms OnOpen event, to check if the current user has access to that form.

To trigger the log in form at start up, just set the LogIn form as the default start up form (Office logo>>Access Options>>Current Database and select the Display form)

 

[James Dudden]

If you're using an mdb then you can use the in-built Access user level security:

http://office.microsoft.com/en-gb/access-help/about-user-level-security-mdb-HP003070410.aspx