Table usage

[Starchildren3317]

Anyone know of an easy way to search through my forms and determine everywhere a certain table is being used without looking at the properties for each individual form?

I have an application built using MSAccess 2003 with a SQL Server back end. I am looking at making changes to a certain table but before I do I want to determine what all the possible impacts are. I essentially need to know what forms in the application are using the table that I intend to alter and because there are many forms in this application I was hoping there was an easy way of going about this.

Any tips, tricks, or ideas are welcome.

Thanks!

 

[jdraw]

A simple, cheap method would be to
Open any Module
Do a find for the table name ( and put a space before and after the name)
Select Current Project
Do a find Next.

The interface will highlight the text string, and it will show the name of the Form involved.

Not elegant, not quick, but it seems a good start.

Another appproach (acc2003 which I have) is to highlight the TableName and then do a View-ObjectDependencies.