Thread: Changing the name of a table that then relates to a query
View Single Post
  #4  
Old January 28th, 2010, 08:12 AM posted to microsoft.public.access.tablesdbdesign
Piet Linden[_2_]
external usenet poster
  
Posts: 280
Default Changing the name of a table that then relates to a query
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...