MS Access global change of fieldnames 1

[Horry]

Is there a way to change fieldnames in an Access database (forms, reports, VB scripts) globally. I have thousands of changes to make and a global change function would be great.

 

[MichaelRed]

There is no specific Global search and replace in Ms. Access, but 'rolling your own' isn't very hard.

Just itterate through the collections - down to the specific doc. level. Open eack/every one and parse each object for your old field name, replace w/ the new.


If it is a large project, it would be worth it.

Seperatly, WHY would you do such a thing? If the process works, I would adopt the old adage "If it ain't broke - DON'T Fix IT!"



MichaelRed
mred@duvallgroup.com
There is never time to do it right but there is always time to do it over

 

[NightOwl]

I have use a product called find and replace. It is excellent!!!!

http://www.rickworld.com/download.html

P.S I HAVE NO RELATIONSHIP WITH THIS PRODUCT