How to review security (use code)? Access 97

[MrTibbs]

Access '97
I have googled, searced M$ and these forums but have not found an answer to my question. Given the vintage of the software being used the problem must have been solved .. I just need to track down the solution.

How can I review and document security in my split database? I have admin rights in both front and back ends and direct access to both.

My ideal would be a report or export that provided a simple summary containing 3 pieces of information.

Object (table / form / whatever )
Group
Access permitted .

Any pointers please?

 

[Pat Hartman]

I belive that I've seen articles on accessing security items from VBA in the MSDN library.
Exploring Microsoft Access Security
http://msdn.microsoft.com/library/d...2000/html/acdecSecureDatabaseS.asp?frame=true
Also look up this article:
208789 - ACC2000 How to Create Your Own Custom Security Reports

 

[ghudson]

Access has a built in Analyzer function that will answer what you have asked.

Tools / Analyze / Documenter

I have seen other posts in the past about some freeware that is more flexible than the built in Access analyzer. Search for the keyword "analyze" and see what you find.

HTH

 

[MrTibbs]

access 97 security documenting / documentation

MSDN has documentation on ADO and .NET .. nothing found on DAO as used in Access '97.

Access '97 Documenter, for this project, takes over 8 hours to run and keeps stopping to tell me about missing queries it cannot analyse due to missing temporary tables :-( .

I have removed all data from a copy of my project to try and speed up the Documenter ..

This is a project that evolved over the last 4 years: The security documentation and revision control needs improvement as the database is to be rolled out across multiple plants.

I have reviewed these forums looking for 'analyze' but have not found anything relevant yet. Anyone got any further pointers?

 

[Pat Hartman]

Did you try the kb article? I know it says A2K but it is using DAO. Copy it and paste it to see if it compiles or search the kb for an earlier version:

ACC2000: How to Create Your Own Custom Security Reports

 

[MrTibbs]

Thank you. KB 208789 works access '97 security documented

Pat,

I did look for an earlier version but disregarded KB 208789 because it said it was for Access 2000

Copy / Paste as suggested .. write a wrapper around the function because I have never found the immediate window on Access '97 and it created the tables with the security cross-references I was seeking.

Thank you.

My wrapper sub ..
Public Sub AccSecurity()
If UtilSecTbls() Then
End If

End Sub

And a rough SQL query to read all the tables and dump the data

SELECT UTL_DbObjsTable.DocID, UTL_DbObjsTable.Docname, UTL_DbObjsTable.docType, UTL_PermTable.PermissionsID, UTL_PermTable.PermissionsDesc, UTL_UsrPermTable.AccountID, UTL_UsrPermTable.docId, UTL_UsrPermTable.PermissionsId, UTL_USRTable.AccountID, UTL_USRTable.Type
FROM (UTL_PermTable INNER JOIN (UTL_DbObjsTable INNER JOIN UTL_UsrPermTable ON UTL_DbObjsTable.DocID = UTL_UsrPermTable.docId) ON UTL_PermTable.PermissionsID = UTL_UsrPermTable.PermissionsId) INNER JOIN UTL_USRTable ON UTL_UsrPermTable.AccountID = UTL_USRTable.AccountID;

IT looks good so far !