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:
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
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.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
