Permissions

  • Thread starter Thread starter Bruce B
  • Start date Start date
B

Bruce B

Hi, I'm working on setting permissions on an Access
Database at the folder and file level. I've found out
previously that in order to make an mdb read-only it's
folder has to have "full control" while the read only is
set on the mdb file itself. This seems to work for read-
only but when I set the permissions on the mdb to Read,
Write and Execute it is allowing design changes. Is this
correct and what do I need to do or can I do at the file
level to prevent design changes? At this time I do not
want to get involved with user level security if
possible. Thanks.
 
If you allow Write on the *file*, users will be able to
modify the design of Access Objects.

The proper way is to use Access Security.

Try also converting your database file to .MDE format.

Check Access Help topic "About MDE files".

HTH
Van T. Dinh
MVP (Access)
 
Back
Top