Permission for Every File in Access

[Mohamed Kadhim]

I need to set pemission on each file such as (Tables,
Queries, Forms, So on), I Know How I can set Permission
on the Database but I have some problems when I set
permission for every file Please I need the help.
Thanks

 

[Immanuel Sibero]

Hi

Microsoft Access security requires some time, effort, and lots of testing to
master.

- Do an article search for Article #207793 on MS Knowledgebase.
- Follow each step exactly.

Beyond that, the great people in this forum would be more than happy to
help.


Good luck

Immanuel Sibero

 

[Lynn Trapp]

First of all, the Tables, Queries, Forms, etc. are not separate files. An
Access database exists as a single file that contains all those objects.
Thus, if you have set network permissions on the .mdb file, those
permissions will carry for all objects int he database. However, if you want
more detailed security you should follow the steps in the Security FAQ from
Microsoft. There is a link to it below.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Security FAQ: http://support.microsoft.com/support/access/content/secfaq.asp