Changing the table name

[Boon]

Hello,

I have a table "Customer" in my database. I have built several queries that
query from this table.

Now, I want to change the name of this table. But when I do this, the
queries won't work. I need to go into each query and rename the table. This
is painful.

Do you have any suggestions, ideas how I can overcome this tedious works?

Thanks a bunch.

 

[Jeanette Cunningham]

Hi Boon,

As long as you dot all of the i's and cross all of the t's you'll be fine.
Renaming a field can be very tedious but it can be done. Be sure to do the
obvious things like make and keep a back-up. Also be sure to watch for Event
procedure that become disconnected from controls if you rename the control.

Fortunately there are some tools that can help you -
"Find and Replace" and is available as shareware:
http://www.rickworld.com/products.html.

Speed Ferret -
http://www.moshannon.com/.

There is also a free one - V-Tools freeware -
www.skrol29.com.

Total Access Analyzer -
http://fmsinc.com/


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Gina Whipp]

Boon,

While I never used this utility I hear (actually, read) good things about
it... http://www.rickworld.com/products.html

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm