How do I make it so that my Access databse cannot be copied?

[Guest]

How do I make an Access database so that it cannot be copied? Right now we
have a database that we are getting ready to put on the server, but we need
to make sure that there is no way to copy the file.

Is there a way to do this in Access, and if not can anyone recommend a
database technology that can do this (maybe Oracle or SQL server?).

Any responses are appreciated.

 

[Lynn Trapp]

There isn't a way to completely prevent someone from copying a file. You can
do a few things to make it more difficult.

1. Put the database in a hidden share, thus making it difficult for users
to find it.
2. Implement User Level Security and lock down the Users Group from having
access to any of the data -- i.e. give them access only through RWOP
queries.

If that isn't secure enough for you, then you will definitely need to
migrate your data to SQL Server or Oracle.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[Guest]

Lynn, thanks for the response. Are there any third-party add-ons which might
be capable of providing this level of security, or is there just a
fundemental problem in the fact that Access is a file-based system?

 

[Lynn Trapp]

or is there just a fundemental problem in the fact that Access is a

file-based system?

You have hit the nail on the head there. Anyone that is determined enough to
get at your file can do so.