Linked Table Protection

[Guest]

I have Two Databases

1) Master Database
2) Reporting database

The Master Database has a dozen tables. One table is Creditor Dues Table.
The Reporting Database is given a link to the Master Database for the
Creditors Dues Table

I want to ensure that no corrections are done (even by myself) are done to
the Creditors Dues Table when reporting database is being used.

The link should be made view/read only.

How to do this.

 

[Willem]

Lock the table as soon as you open the reports database. Open a form
based on the table and set the record locks property to all records.
There is probably a method to do the same in code, but I don't have
that sample at present.

 

[Arvin Meyer [MVP]]

Try using Access User-level security. First read the Security FAQ, then
have a look at some of the links below:

Security FAQ
http://support.microsoft.com/download/support/mslfiles/SECFAQ.EXE

Lynn Trapp's summarization:
http://www.ltcomputerdesigns.com/The10Steps.htm

http://support.microsoft.com/default.aspx?scid=KB;en-us;q165009
http://download.microsoft.com/download/access97/faq1/1/win98/en-us/secfaq.exe
http://support.microsoft.com/default.aspx?kbid=325261

Joan Wild's Access security pages:
http://www.jmwild.com/security02.htm
http://www.jmwild.com/security97.htm
http://www.jmwild.com/SecureNoLogin.htm
http://www.jmwild.com/Unsecure.htm
--
Arvin Meyer, MCP, MVP
Free MS-Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com