Add user and set permisions for each table

  • Thread starter Thread starter Dei
  • Start date Start date
D

Dei

Hi,

I connected to a protected Access Database using an user and password.
How can I add a new user and how can I set his permissions for each table
from Database.
From Access this is very simple. Tools->Security->User and Group
permisions...

Thanks,
Daniel
 
¤ Hi,
¤
¤ I connected to a protected Access Database using an user and password.
¤ How can I add a new user and how can I set his permissions for each table
¤ from Database.
¤ From Access this is very simple. Tools->Security->User and Group
¤ permisions...

You should be able to use Access DDL SQL to do this. See the Managing Security section in the below
MSDN article:

Advanced Microsoft Jet SQL for Access 2000
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/acadvsql.asp


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
Back
Top