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/tutorials...e-hierarc.aspx

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.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Aimee Proctor" wrote:

> 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/tutorials...e-hierarc.aspx
> .
>

On Jan 26, 8:29*am, Aimee Proctor wrote:
> 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...