How to list items connected to tables?

[domino3]

I want to split a table into two different portions and rename them. I therefore would like to be able to see what changes I need to make to any existing connections, rather than change the table names and then wait for the error messages to show up when I try to run queries and reports?

Is there any way of producing a list of which queries, forms, macros and reports are connected to any one table in access 97?

Thank you

 

[lespaul]

I believe under Tools you will find the Database Documenter which should be able to give you what you are looking for.

Also, JeremyNYC has a downloadable program on his website that's an Access Documenter that may be more what you are looking for:

http://www.alphabetcitydataworks.com

HTH

leslie

 

[DanJR]

I reckon this might be worth looking at:

http://www.mvps.org/access/modules/mdl0056.htm

You could use it to search for the name of your table.

Form the website...."The Search Wizard is an Access 2000 addin (*.mda), provided with source, which allows you to search a particular string in Tables, Queries, Forms, Form Class Modules, Standard and Class Modules, Reports, and Report Class Modules. The wizard searches the VBA code and design time properties of the controls as well"

Cheers
Dan

 

[domino3]

Thanks for the replies.

The database documenter lets me see the details of the table itself, and the links to other tables. However, what I would like is a list of the queries and forms the table is used in, and the documenter would only show me that if I went through every query and form individually.

Is there any way of just producing this type of list easily?

 

[RoyVidar]

Hi!

You might perhaps take a look at this thread thread705-751080, and bbooffin's sample. You could then either go thru the text files manually (search for table/field names) or do a programatic search to create your list.

Another option to test, if you have the possibility of using access 2000 or higher, convert the datebase to that version. Then rely on the Name Correct options available from the 2000 version, then convert back to 97 afterwards. These options mostly works as they should, reflecting changes in tables for forms, reports and queries, but not code (but backup, backup, backup;-)).

Roy-Vidar