ACCESS 2000: Prevent copying & printing

[nasus]

One of our managers would like access to our Access 2000 database from home. As it is a very useful marketing database (intellectual property). I am concerned that tables can be printed and/or the database saved down to a hard disk. Is there any way to protect the database?
Many thanks for any help or advice.

 

[Garridon]

You can encrypt the database by using Microsoft's security and permissions. I used the security on mine to keep people from accessing the different department's records. The permissions can be set up so that if someone tries to look at the database design, it won't let them unless they have the permissions established. Yet they can still enter data.

I think there's a FAQ on the General Access questions that goes into more details about security.

Linda Adams (Garridon@aol.com)
"The Importance of Being Grammarian," published in The Toastmaster, March 2001

http://www.geocities.com/hallona_2000

http://www.david-hedison.com