User Permissions

[dhstein]

From what I've read, it seems that user accounts and user permissions are not
very robust in Access 2007. I'd like to provide the information in the
database for some users without giving them the ability to make changes. Is
there a way to do that? Is it straightforward or very complicated ? Thanks
for any light you can shed on this.

 

[Chris O''C]

Access 2007 uses the same user level security as earlier versions of Access,
just use mdb files not accdb format.

User level security is an advanced topic and very complicated for new users.
You can give users in a custom group read only privs if you want.

Read and study the security faq, practice on a copy of the db, and then
secure the db when you're ready.

http://support.microsoft.com/?id=207793

Chris

 

[John W. Vinson]

From what I've read, it seems that user accounts and user permissions are not
very robust in Access 2007. I'd like to provide the information in the
database for some users without giving them the ability to make changes. Is
there a way to do that? Is it straightforward or very complicated ? Thanks
for any light you can shed on this.

My understanding is that workgroup security was REMOVED from A2007, and it is
simply not available the new .accdb format. You can create and secure a .mdb
file in 2003 and *use* it in 2007, but AFAIK (I don't have it installed!) you
cannot secure a database in the new version.

 

[John W. Vinson]

It's been removed only for *accdb* format dbs. Access 2007 supports user
level security for all mdb formats, including Access 2007 mdbs. You can
create and secure Access 2000 to 2007 mdb formats in Access 2007.

Thanks, Chris. I'll correct my advice.