Folder Permissions\Access 2007

[Sam]

We are using a simple (four field) db that was created in ACCESS 2003 with
an ACCESS 2007 front end User are only supposed to use the drop down in one
field to change data. Some users keep adding data to some fields corrupting
the db. Some of these fields need to edited by the db a support person.

Weare doing away with the drop down box and need to allow users to read
only and allow the support staff only to make changes to the db. Do we do
these permissions on the folder level or the DB level?

Why should we change the db to 2007 from ACCESS 2003?



Thanks,

Sam

 

[Jerry Whittle]

You need to institute user-level security at the database level and set
permissions there. This is quite a bit of work.

If you chose to use user-level security, the database must be in the 2003
MDB file format as the Access 2007 accdb file format doesn't support
user-level security. You Access 2007 front end will not work.