How to restrict the DB

Denise · Sep 9, 2004

Lately, we seem to be having a lot of LOST RECORDS in the
database. Is there any way that I can put a LOCK on a
specific field so that only a single person can make
edits to that field? Our database was built on Access
2000 and is on a share server drive so everyone can
enter infromation, run reports, ect. How can I solve this
problem. Any help or suggestions will be appreciated.

Denise

Arvin Meyer · Sep 9, 2004

Depending upon the trust level you have with your employees, you can either
implement full Access user-level security:

http://download.microsoft.com/download/access97/faq1/1/WIN98/EN-US/Secfaq.exe

You can also use the following to lock or unlock fields depending upon the
user:

http://www.mvps.org/access/api/api0008.htm
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access