Hi All-

I am using Access 2007 to create a database that will allow different users different rights and privileges. For instance I would ideally like 2 accounts, an admin that has full rights and access to the database and another user to have limited rights. I think I have the code to prompt a username and password upon entry working well but is there a way to unlock or lock editing privileges (design view) and hide unnecessary tables and forms dependent upon the username? Essentially to clean up and streamline the database for a user with limit knowledge about Access and computers in general, but also allow admin rights for maintenance etc for other users.

Is this possible?

Thanks
Nate

do you have a split FE and BE? are the users using an accde file ?

Hi Nate,

In addition to splitting the BE, take a look at Dane's demo in the Code Archive:

Advanced Custom Password

Hope that helps...

I do not have a split FE or BE. Is that necessary for this task? The users are using a accde file.

Thanks for that link ill take a look at it.

if you have a split BE and FE all the tables would be on the BE and linked from the FE. If you are using an accde file what would the "admin" be expected to ?

Hi,


I highly recommend splitting your database. See this wiki article on how to properly share a database for reasons why: Sharing

Just my 2 cents...