Changing a field name in all my queries and reports

[Leslie Porter OHV]

i tried to search and found alot of stuff that didnt pertain to what i need
so ill ask..

i have to change a few fields in some MySQL linked tables. thus i also need
to update those changes in alot of queries and reports. is there an easy way
to find and replace?

Leslie

 

[Stefan Hoffmann]

hi Leslie,

i have to change a few fields in some MySQL linked tables. thus i also need
to update those changes in alot of queries and reports. is there an easy way
to find and replace?

Link your table under another name. Create a new query, name it like the
old linked table. Rename the columns to the old column names.


mfG
--> stefan <--

 

[Leslie Porter OHV]

yea but i could see this leading to alot of confusion later. i take it there
is no easy way to do this?

 

[Stefan Hoffmann]

hi Leslie,

yea but i could see this leading to alot of confusion later. i take it there
is no easy way to do this?

Not really, you may take a look at the tools from fmsinc.com. They may
help...


mfG
--> stefan <--

 

[boblarson]

Go get V-Tools (free) from here
http://www.skrol29.com/dev/en_vtools.htm
and use their Total Deep Search. It can replace those.

--

Bob Larson
Access MVP
Access World Forums Administrator
Utter Access VIP
Free Access Resources at http://www.btabdevelopment.com

 

[Larry Linson]

i tried to search and found alot of stuff that didnt pertain to what i need
so ill ask..

i have to change a few fields in some MySQL linked tables. thus i also
need
to update those changes in alot of queries and reports. is there an easy
way
to find and replace?

There are two third-party products that do this and get good reports.

(1) Rick Fisher's Find & Replace, http://www.rickworld.com, shareware, try
it free for 30 (I think) days, all updated through Access 2003, but I don't
know about Access 2007.

(2) Speed Ferret, http://www.moshannon.com, commercial software -- note,
this one has not been updated so you will have to have Access 2002 or
earlier installed to use it -- I've used and liked it in the past, but not
being able to run it with Access 2003 has kept me from making good use of
it, recently.

Larry Linson
Microsoft Office Access MVP

 

[Leslie Porter OHV]

i found this util but what is the difference in access 2003 and access XP?

http://www3.bc.sympatico.ca/starthere/findandreplace/

 

[Larry Linson]

i found this util but what is the difference in access 2003
and access XP?

http://www3.bc.sympatico.ca/starthere/findandreplace/

Access 2002 (aka XP) and 2003 have a common file format, and both can save
the database as an Access 2000 file format, as well. Generally, you will
not have difficulty executing a database created in 2003, using Access 2002,
and vice-versa.

However, Speed Ferret apparently checks the version number of Access being
used in the Database and will not run with Access later than 2002. As to
the one you reference, I don't know anything about it.

If you download it, and try it, please post back here to let us know what
you think of it.

Larry

 

[boblarson]

I've had good reports (as well as knowing first-hand, from personal
experience) that the FREE V-Tools Total Deep Search works for everything but
in data. It will replace any text for any object or property in the db, but
it will not change data.

Bob Larson