Renaming fields and tracing dependencies

        1 votes: *****     3,12 views      No comments
by Allen Browne, 20 April 2005    (for 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: PoorYour rating: Not so goodYour rating: AverageYour rating: GoodYour 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)

Comments require approval before being displayed on this page (allow 24 hours).