General discussion


Securing MS Access Tables & Queries

By cwz ·
I'd like to find a simple method to protect my Access 2000
tables and queries from being imported into another Access
database. I've got my Database Window locked down tight,
all my Startup options set the way I want but I still
can't prevent someone from opening a new database, going
to the File menu and importing all the tables and queries
from my database. If there were a way to gray out the
tables and queries from the import dialog, just like the
forms and modules are when you compile a database, that
would be ideal. I've looked at user level security and I'm
afraid that it would over complicate my distribution
method and may even interfere with existing workgroups.
I've also tried to set the Hidden property on tables but
that is too easy to defeat.



This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by simran In reply to Securing MS Access Tables ...

Head over to :

I'm sure you'll find yoour answer there.


Collapse -

Change the owner

by Glen_McLeod In reply to Securing MS Access Tables ...

If you've locked down your Access database, then I'm assuming that you've created users and groups in the workgroup file, and assigned permissons to the groups. What you have to do now is to create a user that is in the administrator group, assign ownership to all the objects to this new admin user, then remove the default administrator account from the workgroup. That way when another, unsecured, copy of access is opened, by default using the administrator account, it won't have any permisssions in your database file.


Related Discussions

Related Forums