Securing Tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

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???
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

table security 1
Is it possible to create an MDE from an Access 2000 DB with ULS 3
User Level Security Enquiry 1
Problem in securing data base 1
Securing tables 1
I can't generate one Module MDE in Access 2002,2003. 2
Prevent Importing / Linkage via Security 3
Splitting in 2000/2003 environment 8

Back
Top