User access

[Hiramicus]

I'm using access 2003. I want to be able to set a DB to have user name's and passwords, which will restrict access to editing specified queries/tables. I'm not sure what I should be searching for. Can someone direct me to keywords/access fields to be able to do this?

thanks!

[tasawer]

Hi,

1. Set Public Global Variable
2. Create Table of Names, Passwords and user types.
3. Give each type a number that will act as security level indicator
4. When user logs in successfully, set the Global Variable to their security level number.
5. When each form is opened, run an IF THEN ELSE Statement on the global variable to enable or disable commands and textboxes etc.

Hope this helps.