Posted on 2013-10-07
I have an old database which contains several forms, reports, queries, tables, etc. But now I have a chance to clean it up and only keep the objects that are necessary. I've created a new empty database and have copied over from the old database the main menu or dashboard from which all reports, forms, etc. are launched.
But here is my question... is there an easy way to determine which other forms, queries, tables, reports are needed to be copied over also from a command button on the main menu?
In other words, for example, if I have a command button on the main menu which when clicked opens a report that may have a query as it's record source, is there an easy way to know which tables, queries, and report I also need to copy over to the new database?
Maybe there is a tool out there that I am unaware of or maybe there even is a way within Access to gather this information?