Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Changing a field name in entire database
- Thread starter Michael57
- Start date
- Thread starter
- #3
Hi
Depending on version of Access, the Name Autocorrect (see tools \ options)feature may allow you to change name in objects, eg forms, table, querydefs, but if you have any VBA code which refers to the column name, you will have to amend that with search and replace.
I believe there are also third party products available to do this, but I have not used them
Regards
Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now - UK
Depending on version of Access, the Name Autocorrect (see tools \ options)feature may allow you to change name in objects, eg forms, table, querydefs, but if you have any VBA code which refers to the column name, you will have to amend that with search and replace.
I believe there are also third party products available to do this, but I have not used them
Regards
Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now - UK
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question