Finding unused objects in Access 2000

[briandh]

I have a database that has been upgraded/updated over the years. I know there are some tables, queries, reports, etc. that are not linked to anything. Is there a way to see if a certain table is being used by any other object in the database before I delete it? I can always make a backup of the database and use the trial & error method - delete a table, see if the DB works, but that would take a long time with a database this size.

Any suggestions?

Thanks in advance!

Brian

 

[JeremyNYC]

Brian,

Rick Fisher's Find n Replace utility has a function that looks for unused objects. It's a great tool, and well worth whatever it costs (I bought it so long ago I don't remember the cost). You can check it out at

http://www.rickworld.com.

Jeremy

==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Affordable Development, Professionally Done

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.

 

[MichaelRed]

An altogether free resource is the MSysObjects table within Ms. A. itself. It is only 'free' in the monentary sense, as I know of no real documentation on the content of this or the other system tables and Ms. PROMISES to not provide any official docs as they reserve the right to modify the content and even the meaning of established fields. There are some rather obvious relationships / meanings of hte various fields, but most take a lot of 'review/analysis' to decypher the meaning - even within a specific ver of Ms. A.

At the very least, review of the table should readily reveal the complete list of objects in the db, including any linked tables from other dbs. What it will not reveal is onjects created or instantiated in code (e.g. Run-time objects), but then I'm not aware of a utility which does include these.

Another commercial product is "SppdFerret", which has been reviewed and recommended in the trade press. I do not own the product or have any interest in the companyy which sells it, but have only seen posititve review and commentary on it's capability.





MichaelRed
m.red@att.net

Searching for employment in all the wrong places

 

[briandh]

Thank you for your replies! I am looking into both of them.

Thanks Again,

Brian