Hi,

I wonder if any of you could help me with what I assume to be a simple request, but one I've stuggled to find an answer to in the 'help' searches that I've done.

I'm working with an Access 2003 database that was originally designed to use a copy of a live table held elsewhere (this copy only used a subset of the fields from the main table). I now need to change the database so that it references the live table only, to ensure data integrity. To do this, I want to remove the 'copy table' and make all forms, queries, reports, macros etc. refer to the live table instead.

Is there a 'where used' procedure that I can run to find all the objects that use this table, rather than my having to go through every single one and check if this table is referenced (there are hundreds of such objects in this database)?

Thanks for your time,

Right click the table name in the database view, a list of actions popus up. One of them gives all the object utilizing the table. It's a new function in A2003.

Thanks for this - I've switched the 'Track Name Autocorrect Info' option on and am currently generating all object dependencies for the database, so I should shortly be able to locate every place where my table is used.

Well, not quite every place. This feature does not track usage in code and I'm not sure about macros either.

Thanks Pat - the code isn't an issue, as I've been able to do a 'find' search for that, looking for usage of the table name in question, and the system uses macros to run a collection of queries or reports, so I've located them through the query checks anyway. Even if I do miss anyway, the testing process should locate them, and this way I can be fairly sure that I've got the majority of them.