Get the users's permisions for each table

[Dei]

Hi,

I have a protected Access Database (with different tables) and an user
with different permisions for every table. How can I get the user's
permisions for every table?

Daniel

 

[Mary Chipman]

You can use DAO or ADOX code for this -- there are examples in the
Access Help files and in the Access security FAQ which is posted
somewhere on msdn. However, you should realize that Access security is
not at all secure and is probably a waste of your time if you are
looking for anything more than simple deterrence. Anyone who is
interested in cracking it can easily do so with a simple google search
for the vendors who will deliver an administrative login and password
for a nominal price.

--Mary

 

[Paul Clement]

¤ Hi,
¤
¤ I have a protected Access Database (with different tables) and an user
¤ with different permisions for every table. How can I get the user's
¤ permisions for every table?

Here is an example of the ADOX (Microsoft ADO Ext 2.x for DDL and Security) method Mary was
referring to:

http://msdn.microsoft.com/library/d...en-us/odeopg/html/deovrreadingpermissions.asp
http://msdn.microsoft.com/library/d...do270/htm/admscgrantingpermissionsexample.asp


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