General discussion

Locked

MS Access Security

By jrussell ·
I'm looking for a utility or VB code that can generate a report on the security of an Access 97 Database. The report would need to display each object in the database and the permissions each user/group has on that object. For example...

Table:DepartmentMaster
User: Admin
Read Design, Modify Design, (etc)
Group: Users
Read Data, Update Data, InsertData

Any help would be greatly appreciated.

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

MS Access Security

by DKlippert In reply to MS Access Security

Have you tried Tools Analyze Documenter?

Collapse -

MS Access Security

by jrussell In reply to MS Access Security

Yes, I have looked at the Tools | Analyze | Documenter, however, that report does not give me the level of detail I need. The canned report shows a list of users and groups, but not the explicit permissions on the objects.

Collapse -

MS Access Security

by ESchlangen In reply to MS Access Security

The Access 97 Developer's Handbook by Litwin, Getz, and Gilbert, (Sybex)Copyright 1997, has several functions that could be modified to do what you want. Two in particular that will allow you to cycle through each user and then cycle through that user's permissions are adhListUsersWithBlankPwd and adhCheckPermission. You will probably have to go to a library to find this book, as I'm pretty sure it's out of print.

Collapse -

MS Access Security

by jrussell In reply to MS Access Security

Poster rated this answer

Collapse -

MS Access Security

by jrussell In reply to MS Access Security

This question was closed by the author

Back to Web Development Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums