Password

[llldnylll]

Is there a way in Access to have two different passwords?

I need one for administrator and the other to read only.

 

[willir]

If you set up different groups, you can give one group administrative access and the other restricted access.

From the menu, "Tools" -> "Security"

Review the following article by MS for more info. When you implement security, you should be aware of the benefits, implications and limitations.

Oh yea, backup your database too.

Richard

 

[willir]

Whoops - wrong button
ACC: Microsoft Access Security FAQ Available in Download Center

 

[ZmrAbdulla]

You can also read it as a tutorial Access Security Overview

Zameer Abdulla
_{Jack of Visual Basic Programming, Master in Dining & Sleeping}
Visit Me