Tidying up orphan forms and queries

  • Thread starter Thread starter Richard
  • Start date Start date
R

Richard

A housekeeping problem, I have a database in constant development for 2
years as I get better at it I replace forms, queries etc but end up with
rather a lot of unused forms and queries.

The complexity of my database makes it difficult to just delete these
orphans because I can't remember if they are true orphans or not , or if
some other component is dependant on them.

Is there a simple auditing tool that exposes either unused objects or that
at least maps the dependancies of all objects in a database .

Richard the forgetfull
 
Is there a simple auditing tool that exposes either unused objects or that
at least maps the dependancies of all objects in a database .
Click to expand...

Don't feel lonesome - lots of folks have the same problem!

There are some good third-party tools to help this tedious process:

Free:
http://www3.bc.sympatico.ca/starthere/findandreplace
Find and Replace: http://www.rickworld.com
Speed Ferret: http://www.moshannon.com
Total Access Analyzer: http://www.fmsinc.com

The last of these is the most powerful (and most expensive), and
provides a detailed report of unused objects.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Thank you both .
Richard
John Vinson said:
Don't feel lonesome - lots of folks have the same problem!

There are some good third-party tools to help this tedious process:

Free:
http://www3.bc.sympatico.ca/starthere/findandreplace
Find and Replace: http://www.rickworld.com
Speed Ferret: http://www.moshannon.com
Total Access Analyzer: http://www.fmsinc.com

The last of these is the most powerful (and most expensive), and
provides a detailed report of unused objects.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
Click to expand...
 

Ask a Question

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.

Ask a Question

Similar Threads

How to find Orphan Records ? 3
Options for sppeding up database execution 4
How to print Map or Schematic diagram of our database ? 13
Appending data from two tables to two tables in Access 2000. 1
Access 2002 remove unused objects, forms, queries, macros, modules 1
Pop-up form that creates record that links 1:1 to main form 0
List all row source for all forms, reports etc. 2
Forms/Queries taking up whole screen 3

Back
Top