Protect Database

[Steven]

Is there a way to keep someone from importing from your
database to their database. I know about passwording the
database but I do not want to do this because it is multi-
user where the users must login with thier own id and
password to match the USER table for access. If I password
the actual database I would have to give the password to
everyone anyway. I have seen an ecryptor that works nice
and will tell anyone trying to FILE / GET EXTERNAL DATA /
IMPORT from you database that it cannot read your
database; but it cost $2,000 the last time I looked at it.

Is there another less expensive way to accomplish this?

Thank you ,

Steven

 

[Dirk Goldgar]

Is there a way to keep someone from importing from your
database to their database. I know about passwording the
database but I do not want to do this because it is multi-
user where the users must login with thier own id and
password to match the USER table for access. If I password
the actual database I would have to give the password to
everyone anyway. I have seen an ecryptor that works nice
and will tell anyone trying to FILE / GET EXTERNAL DATA /
IMPORT from you database that it cannot read your
database; but it cost $2,000 the last time I looked at it.

Is there another less expensive way to accomplish this?

It sounds as though you have a home-grown security system involving user IDs
and individual passwords. If you were to apply Access's built-in user-level
security instead, you could secure your database with user IDs and
passwords, and restrict access to the database and tables such that only a
logged-in user can get access to them -- at least not without some serious
password cracking.

User-level security can be a bit tricky to apply correctly, though. If you
choose to go this route, you'll want to read the Access Security FAQ
completely before you begin. It's available at

http://support.microsoft.com/default.aspx?scid=kb;en-us;207793

The document says it's for Access 2000, but its essentials apply to later
versions, too. The Access 2002 (and presumably 2003) security wizard is
much better and more comprehensive than the earlier versions, too.