Table usage in Access

[SimonSellick]

Hi,

I'm planning to port just a few large tables from Access to SQL Server and I want to create a list of objects that use the selected tables so that we can reduce the sccope of acceptance testing.

Inspecting QueryDef.SQL gives me the obvious ones (where the table is used in a view, query, form data source or combo row source.

Does anyone know how to do the same task (in VBA) for macros, reports and modules? These don't appear to have nice simple collections as tables and queries have.

Any help appreciated.

 

[PHV]

Have a look here:

http://www.jrbarnett.freeserve.co.uk/mdbdoc.htm

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[SimonSellick]

Thanks PHV, I've downloaded it and it's running now. Unfortunately, I'm analysing an Access 97 db, and the Access 97 version of mdbdoc doesn't do individual objects and I can't get at the source code (module tab shows 'Design' greyed out). Stil, I'll see what output it produces.