Looking for structure of an Access 97 mdb file

[fal762]

Hi all,
I recently inherited mainainence of an Access 97 mdb that consists of several dozen macro, several dozen queries used by the macros and several dozen import load mask specs. There are no forms or reports but a few tables without data that the queries reference. Data from an upstream application is imported into an Access table and then a macro manipulates the data and exports it for use by a downstream application.

My problem is that it is almost impossible to keep track of the dependencies. If I modify one query then I end up breaking another macro, etc.

Is there any Access data dictionary table/collection/object that contains more information than Msysobjects? What I am looking for is a way to determine what queries and import load specs are used by a macro. I would love to know what macros are dependent upon a query and what querys are no longer being used.

I know the information I need is contained somewhere in the mdb file. Can someone point me in the right direction?

Thanks.

 

[jrbarnett]

Have you tried the Access database documenter? It may well be more than you need, but is something to go on.
It is not part of a standard installation, but should be available from the Tools -> Analyze -> Documenter in my Access 2002, but it can't be that different in 97. I don't have an installation to hand unfortunately to check the exact location for you but perhaps someone else can help.

John

 

[MichaelRed]

Documenter has been under tools for as long as I recall.

I would SUGGEST that you convert all of the macros to code as a FIRST Step. Even if you retain / use the macros (NOT recommended) the modules code is easier to read and understand than the macos.





MichaelRed
m.red@att.net

Searching for employment in all the wrong places