dbTalk Databases Forums  

Find out where a table is being used

comp.database.ms-access comp.database.ms-access


Discuss Find out where a table is being used in the comp.database.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Iman Mayes
 
Posts: n/a

Default Find out where a table is being used - 08-30-2004 , 10:04 AM






Hi,

I have tried searching already, but I cannot seem to find an easy way
to find out where a table is being used (reports, queries, etc.)
within an access database. Using the regular search from within the
modules will show me the function (within the modules) and Forms that
are being used, but not the queries and reports.

I am using access 97, and would like to know if there is a way I could
just take the name of a table and easily find ALL places it is being
used within the database.

Thanks,

Iman

Reply With Quote
  #2  
Old   
Ira Solomon
 
Posts: n/a

Default Re: Find out where a table is being used - 09-01-2004 , 07:20 AM






I know of no free way to do this.
Goto:
http://www.moshannon.com/

and look at Speed Ferret

If you do Access seriously this is a tool you can't live with out.

There are documentation [products from FMS that will do this as well,
but more expensive and I don't believe they can do the replace
function in Speed Ferret.

Good Luck
Ira Solomon

On 30 Aug 2004 08:04:50 -0700, iman.mayes (AT) abfsonline (DOT) com (Iman Mayes)
wrote:

Quote:
Hi,

I have tried searching already, but I cannot seem to find an easy way
to find out where a table is being used (reports, queries, etc.)
within an access database. Using the regular search from within the
modules will show me the function (within the modules) and Forms that
are being used, but not the queries and reports.

I am using access 97, and would like to know if there is a way I could
just take the name of a table and easily find ALL places it is being
used within the database.

Thanks,

Iman


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.