ACCESS Object References...

[GUIDO22]

I am cleaning up a database that has been around for some time and I wish to be able to check for references within REPORTS/VBA Module code/ Form Designs etc. anywhere there is likely to be a reference to either an Access TABLE or QUERY.... I know there is the 'Object Dependancies' function within Access that will go some way to telling you what relies on what, but this is simply not comprehensive enough in that it doesnt go down to Form design level where further references can hide...

Countless times I have checked and subsequently deleted tables that I considered redundant... only to find later on there was some SQL Source reference to a table or query buried in the design of a form that I had overlooked....

Does anyone know of a way to definitively check and to ensure that all traces of a specific table or query are accounted for...?

Thanks in advance for any help offered.

Regards
G

 

[CJ_London]

in the vba editor you can 'find' your table name in all modules to see if it is still referred to.

 

[Galaxiom]

V-tools Total Deep Search.