Renaming fields and tracing dependencies

        1 vote: *****      3,068 views      0 comments
by Allen Browne, 20 April 2005    (Access 2000+)

Microsoft Access Tips for Serious Users

Provided by Chas Dillon, November 2003. Updated May 2006.

Renaming fields and tracing dependencies

If you rename a field in a table, you must also change that name in each query, report, macro, and module that refers to the field. How do you find all instances?

Access 2000 and later provide Name AutoCorrect options: Tools | Options | General in Access 2000 - 2003, or in Access 2007: Office Button | Access Options | Current Database. However, the built-in tool is buggy, incomplete, and is a performance nightmare. Access 2003 provides dependency information directly, but only if you are willing to use the Track name AutoCorrect info.

Chas Dillon has prepared a utility for Access 2000 and later to find and/or alter the name in queries, forms, and reports. It also includes code to document the schema of the database, as a text file and/or as an Access report.

The utility consists of an Access 2000 database containing the code, and a text file explaining its purpose and usage.

You will need to be familiar with VBA to use this utility.

Download the utility

Home Index of tips Top

Rate this article:   Your rating: Poor Your rating: Not so good Your rating: Average Your rating: Good Your rating: Excellent

This is a cached tutorial, reproduced with permission.

Have your say - comment on this article.

What did you think of 'Renaming fields and tracing dependencies'?

No comments yet.

Why not be the first to comment on this article?!

Have your say...

E-mail (e-mail address will be kept private)
Verify Code
Verification Code

It may take 30 seconds after clicking submit - please be patient to avoid duplicate submissions.  

All comments must be approved before being displayed on this web page.  This process may take up to 24 hours.