A
Angie
Is there a quick way to list where tables are referenced
in a database?
in a database?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
John Vinson
Is there a quick way to list where tables are referenced
in a database?
Not readily, not in a builtin way. To fill this gap several
third-party vendors have developed programs to find and edit table
(and query, and form, and control) references in Access. In increasing
order of price and features:
Find and Replace http://www.rickworld.com
Speed Ferret http://www.moshannon.com
Total Access Analyzer http://www.fmsinc.com
C
Cameron Sutherland
If you just want to quikly view them you can open the
System table. Go to Tools~Options~System Objects and make
sure there is a check mark. This will make visible 6
tables. Open the one called MSysObjects and look in the
Connect field. Most records will be blank but all those
that have values are the linked tables. It should display
the Path to Access tables and Connection strings to SQL
Server or ORACLE tables... whatever you have linked. If
you want to list them with code email me and I can help
you there too.
-Cameron Sutherland
System table. Go to Tools~Options~System Objects and make
sure there is a check mark. This will make visible 6
tables. Open the one called MSysObjects and look in the
Connect field. Most records will be blank but all those
that have values are the linked tables. It should display
the Path to Access tables and Connection strings to SQL
Server or ORACLE tables... whatever you have linked. If
you want to list them with code email me and I can help
you there too.
-Cameron Sutherland
K
Karl Dewey
I use the Tools, Analyze, Documenter and select all the
forms, queries, and reports. Select Publish it with MS
Word Will be a big file). Then use the find function.
forms, queries, and reports. Select Publish it with MS
Word Will be a big file). Then use the find function.