Web Development

Ask something
Discussion Locked

MS Access Security

0 helpful
5 replies

by jrussell 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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.

5 replies

by jrussell

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.

by eschlangen

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.

This discussion is closed to new replies.