Changing the name of a table that then relates to a query

[Aimee Proctor]

I changed the name of a table that relates to a lot of queries.....these now wont work....how do i resolve this....thanks for ANY news!


Submitted via EggHeadCafe - Software Developer Portal of Choice
ADO.NET Recursive Hierarchical DataSet Technique
http://www.eggheadcafe.com/tutorial...c3-9143dd2c6da3/adonet-recursive-hierarc.aspx

 

[Jerry Whittle]

1. Change the table name back to its orginal name.

2. Download Rich Fisher's excellent Find and Replace add-in and change
everything to match the new table name. If you register it (one of the best
$37 I've ever spent), the cross-reference report can find what queries use
which reports and forms. It's a good way to find orphans.
http://www.rickworld.com/

3. Enable Name Autocorrect so that you won't have this problem in the
future. However Name Autocorrect is often a problem and I don't recommend
using it.

4. Remember that changing the name of a table, field in a table, query, and
possibly even forms and reports can cause this problem. It's better to get
the names right in the first place or don't mess with them.

 

[Piet Linden]

I changed the name of a table that relates to a lot of queries.....these now wont work....how do i resolve this....thanks for ANY news!

Submitted via EggHeadCafe - Software Developer Portal of Choice
ADO.NET Recursive Hierarchical DataSet Techniquehttp://www.eggheadcafe.com/tutorials/aspnet/f492b744-8326-4671-a7c3-9...

loop through the Querydefs collection and use the Replace function to
modify the SQL property might work...