I need to create a multi-user with user levels such as admin, and read only access database I created. I curently made a login with a password to get in the database but I want to only allow certain people to just have read-only access. I may have to discard the login I created that I found on line to make this work. I have Access 2007 and I have the database split (FE and BE).
Is there a vbscript with directions that I can use to pull their network login as their username and the password I supply them which will give them the appropriate security level I set for them?
Thanks!