Where is this table being used?

[SRAB]

Is there short cut way of discovering what queries, forms, reports or macros are making reference to a particular table? I'd like to make some changes to the layout of a table to make it more efficient, but I know I'll break some queries that rely on the current structure.

 

[Access_guy49]

Click on View and click object dependancies. (gives a list on the right hand side of all tables, forms, reports, queries...)

 

[SRAB]

That's just what I'm looking for, but there is no "object dependencies" in the view menu (Access 2002).

 

[Access_guy49]

Add-IN?

I took a quick look online and apparently that is a new feature with access 2003. Looks to be that your options are either upgrade, search the web (and be comfortable with downloading) an add-in from a 3rd party, or your gona have to tough it out and stick to the old and very long method..

 

[SRAB]

I took a quick look online and apparently that is a new feature with access 2003. Looks to be that your options are either upgrade, search the web (and be comfortable with downloading) an add-in from a 3rd party, or your gona have to tough it out and stick to the old and very long method..

Thanks, maybe I'll ask the powers to be for an upgrade...unless I can get that SQL server I've been asking for.

 

[pbaldy]

I use Speedferret, which costs a few bucks, but I've heard this free tool is very good:

http://www.skrol29.com/dev/en_vtools.htm