unused field names

  • Thread starter Thread starter kennethburr
  • Start date Start date
K

kennethburr

Over the several months that I have been designing this database I have
made many changes. Is there a way that I can easily delete from the
tables and queries any field name that is not referenced by any form or
report?
 
Over the several months that I have been designing this database I have
made many changes. Is there a way that I can easily delete from the
tables and queries any field name that is not referenced by any form or
report?
Click to expand...

If you have A2003, and have taken the risk of bad performance and
corruption involved in using Name Autocorrect, you can look at the
Dependencies report on each.

Or, there are some third-party tools that can make this laborious
process a bit easier:

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

John W. Vinson[MVP]
 
You must log in or register to reply here.

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

Table field name change propogate to queries/reports/forms 1
Record-Locking remains open after closing 0
Copying old records into a new table 3
Can't create a report from my query in Access 1
Finding Field Use 2
AC2007-Change where to send Report. 1
Change Format 2
SQL or Query to identify unused fields in a table? 2

Back
Top