Securing Tables

[Guest]

Is there any one who can help me secure my tables in access.
I have a mde and my clients might not be able to import or link the tables
from
my mde into there databases.
How can I set permissions for each user???

 

[Guest]

The way to secure your tables is to implement user-level security in Access.
Go to Tools\Security\User-Level Security Wizard. It will take you through the
wizard and allow you to choose which tables you want to secure and also which
users that you want to have certain permissions. Another tip is to set a
database password that will protect the entire database itself. This is also
done in Tools\Security. I have included some additional websites that might
be helpful to your situation.

These sites might help:

http://support.microsoft.com/?id=207793

http://support.microsoft.com/?kbid=207793

http://www.geocities.com/jacksonmacd/AJMAccessSecurity.pdf

Dave S.