Queries and Tables Not Referenced 1

[bigoldbulldog]

Does anyone know how to identify tables and queries that are not referenced by other queries?

This is for cleanup of junk objects. Does anyone have any other tips to do this?

Thank you.

Cheers,
ND

bigoldbulldog@hotmail.com

 

[seaport]

That is an intereting thread.

Queries and tables can be referenced in the following places. You can build a search function to see if there is a match.

1. Other queries. With QueryDef object in DAO model, you can search the sql statement of all queries. (QueryDef.sql).

2. In vb codes. You may use "Find" manually, or you can use "module" object to return lines of code so the search can be done by programming.

3. data source or row sources in forms or reports. You may use forms and reports objects to search for the match.

4. table relationships. You may use ADO object model.

5. In table design, certain fields may use another table or query as row source. I am not sure how to handle this. However, this issue seems not important. A table will still work even after the row source of its field is deleted.

Hope this can give you a start. It will be a cool tool if you can get all above done automatically.

Seaport

 

[lespaul]

There's an Access documenter that JeremyNYC built and put on his website. I haven't actually used it, but other threads have mentioned how useful it is. May help you out. Check out

http://www.alphabetcitydataworks.com

pretty sure its in the developer section.

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

 

[seaport]

Leslie,

The "Access Documenter" is not available at that web site. I am very interested in this kind of tool. Do you know anywhere else I can get a copy?

Thanks.

Seaport

 

[lespaul]

my bad, it's not Jeremy, it's JR, here's the correct link

http://www.jrbarnett.freeserve.co.uk/

 

[seaport]

Leslie,

Thanks.

Seaport