FIELD NAME CHANGE IN MICROSOFT ACCESS

[Jackie Aitken]

Hi ya
Would apprediate some help with this. I have created a
Action Database and and it has field called Product,
Market etc. The requester of this database requested these
fields names to be changed. I have created Tables, Forms
Queries and Reports with Command Buttons with these field
names. Is there a quick way that I can do a search and
replace throughout the database to change this without
doing it manually.
Thanks in advance for any assistance or advice given.
Jackie

 

[Peter]

I suppose your requester wants to change field names that
appear on forms and reports. The only way I see, is to
change names at runtime: scan a from/report when it is
opened and reset the caption properties. An other
possibility for tables and queries is to set the caption
properties in the table and query definitions.

 

[Douglas J. Steele]

There are 3rd party products that will help you do this:

Find & Replace: http://www.rickworld.com/products.html
Speed Ferret: http://www.moshannon.com/speedferret.html
Ucora's: http://www3.bc.sympatico.ca/starthere/findandreplace/