Read Only access

[jrowland]

I cannot figure out how to make it so that I am the only person who can
change data in my Access 2007 database and give everyone else Read Only
permission. Please help!!!

 

[Jerry Whittle]

If it's the new 2007 accdb file format, you can't. To do what you want, you
would need user level security but the accdb format doesn't support it. If
you keep the database in the .mdb format, you could enable user level
security.

You could try setting the user's database file permissions to read only.

 

[Mark Andrews]

You can control the application through forms and have your own login
mechanism, setting allowedits = false on forms when the user is not you.
Like the other post said "out of the box" security options are different in
access2007. However access 2003 and earlier security can easily be cracked
so it's no good either.

Mark Andrews
RPT Software
http://www.rptsoftware.com
http://www.donationmanagementsoftware.com