We've inherited an MS Access db/application (Office 2002) with great names such as NewTable, Subform or Macro1. Unfortunately, when we change these to more meaningful names, the references (in other Queries, Forms or Actions) are not updated.
How can we find out where a specific object is used?
Best Answer
MsAccess has an OBJECT DEPENDENCIES checker. in Access 2007, for example, you must:
this whitepage details the process and recommends additional steps that you might wish to take.
In access 2003 and 2000, the process is slightly different, for the interface changed significantly from 2007 onwards