Update Tables in Queries

[John Conklin]

Hello all,

I had to change the name of an existing table from TBL - Header to tblHeader
due to some problems with running certain code elements in my database, and
also because it makes more sense not to have spaces in table names.

My question is then is there any automated way to change the tables I have
queries built on using the first table name with the new table name? This
database has a lot of queries, and I am trying to find a faster way of
change the table.

Thanks
~John

 

[Douglas J. Steele]

Newer versions of Access are supposed to be able to do this for you, but I
prefer some of the 3rd party products that are out there for this purpose:

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/

 

[John Conklin]

Thank you very much Doug...I will give one of them a try.

I appreciate your quick response.

~John