How do I assign read only access to some users and allow update rights to others

[Dave Weaver]

I used the security wizard to create a group of users. I set some to read only and another to Full permissions, but everyone in the group can open and make changes to forms and queries. I also gave each person a password, however, I am the only one that gets a pop up box to enter a password. Everyone else is able to open right into the database

Thanks

 

[Douglas J. Steele]

Sounds as though security wasn't applied correctly. It's a very complicated
process.

Take a look at the Access Security FAQ at
http://support.microsoft.com/support/access/content/secfaq.asp

Read it carefully several times, make sure you don't skip any steps, and
work on a copy of your database.

Another good source of information is Lynn Trapp's security tips
http://www.nwidevelopers.com/Security.htm
http://www.nwidevelopers.com/The10Steps.htm



--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)

I used the security wizard to create a group of users. I set some to read

only and another to Full permissions, but everyone in the group can open and
make changes to forms and queries. I also gave each person a password,
however, I am the only one that gets a pop up box to enter a password.
Everyone else is able to open right into the database.