By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,609 Members | 1,164 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,609 IT Pros & Developers. It's quick & easy.

Repoint all queries in mdb from an old table to a new table

P: n/a
Hi, I use Access2002 SP3. I have taken ownership of a mdb which I
would like to redesign. I want to repoint all current queries from a
daily table to a new historic table. There are over 30 queries
pointing at the old table. Does anyone know of a quick way to repoint
all the queries to a new table?
Regards
KC

Jun 8 '07 #1
Share this Question
Share on Google+
2 Replies

P: n/a
On Fri, 08 Jun 2007 03:14:07 -0700, KayC <ka******@yahoo.co.ukwrote:

If you know VBA you could write code to iterate over the queries
collection, get the SQL property, call Replace, and save.

If not, open each query in design view, switch to sql view, copy the
text in notepad, find & replace, and copy back.

-Tom.

>Hi, I use Access2002 SP3. I have taken ownership of a mdb which I
would like to redesign. I want to repoint all current queries from a
daily table to a new historic table. There are over 30 queries
pointing at the old table. Does anyone know of a quick way to repoint
all the queries to a new table?
Regards
KC
Jun 8 '07 #2

P: n/a
On 8 jun, 11:02, Tom van Stiphout <no.spam.tom7...@cox.netwrote:
On Fri, 08 Jun 2007 03:14:07 -0700, KayC <kay_c...@yahoo.co.ukwrote:

If you know VBA you could write code to iterate over the queries
collection, get the SQL property, call Replace, and save.

If not, open each query in design view, switch to sql view, copy the
text in notepad, find & replace, and copy back.

-Tom.
Hi, I use Access2002 SP3. I have taken ownership of a mdb which I
would like to redesign. I whttp://groups.google.com/group/comp.databases.ms-access/browse_thread/thread/67a7b1ecce413b3d/2439079e5ed82d81#2439079e5ed82d81ant to repoint all current queries from a
daily table to a new historic table. There are over 30 queries
pointing at the old table. Does anyone know of a quick way to repoint
all the queries to a new table?
Regards
KC
If the old table won`t be used anymore, removing/renaming it to
something else, then naming a new query like

SELECT * FROM NEW_Table;

with the old table`s name would do the trick!
Jun 8 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.