P-Track Version 1.0 is a free security permissions utility for Access 97 databases. Unlike the limited permissions documentation in Access, P-Track can easily document them all in a table, as printed reports, and for export to Excel or other formats. You can scan through permissions in bulk, to troubleshoot or look for bad settings. Plus, you can see the overall combined permissions for Users - something that is difficult to do with the standard Access tools. P-Track Version 1.0 does not alter permissions in any way.
This utility is designed for developers or database administrators with medium to large-size secure databases. Setup is easy - just import a few objects from P-Track into your application and you can immediately begin to document the permissions.
Download 97 zipped (111k)
Below is a sample screenshot of the main menu. The upper left tab has select lists for Users and Groups and the upper right tab has select lists for Database Objects. In the lower section are buttons for running the process, and opening and filtering the results and reports, and for clearing out the results.
Below is a screenshot of the results datasheet, with the quick filter dialog box near the bottom. In this case, it is filtered to User 'Hawkins' showing combined permissions (implicit and explicit).
The first screen shot below is the report filtering menu. In this case, it is showing the same criteria - User Hawkins' combined permissions. The second screen shot below is the filtered report.
Download 97 zipped (111k)