Table - Is it used?

[Scottie31]

An employee that created a database left our company and now I have the fun of maintaining it. I have noticed that there are several table that were created which are not linked to another database but have lots of information which will need to be updated manually. This information could have been linked very easily and saved a lot of work. Is there an easy way to find out if this table is used in any queries? Any help would be greatly appreciated.

 

[CraigDolphin]

If you have Access 2003+ you should be able to view object dependencies for the tables in question. From (dim) memory, you do this by right clicking on the table in the database window and selecting the object dependencies item from the right-click menu.

Sorry to be vague....I use A2k at work which doesn't have that functionality and haven't used A2003 for quite some time now.

Otherwise, I think you're stuck looking through all the stored query defs and looking manually. And if you do that, make sure to check the record source for forms too in case the recordsource sql that references the table has not been saved as a stored query (ie, it only exists in the recordsource property of the form)

Hope it helps

 

[DJkarl]

Easy way - Hire the employee back and ask them.

As that's probably not an option, there really isn't any easy way to tell what forms, queries or reports might be using a table. You could try renaming it and see if anything blows up, then you'd have at least an idea. Apart from that it would require you to look at every object to see if it uses the table in question.

 

[georgedwilkinson]

Sorry I didn't notice this thread before. There is a nifty tool that will help you out here called v-tools: http://www.skrol29.com/dev/en_vtools.htm.

You can get a lot of information using this.

 

[CraigDolphin]

Useful link! Thanks George