Hi,
I need to change a table name referenced in > 100 queries. The queries did not pick up the rename of the table. Is there an easy way to do this ?

Thanks

Peter Clements

Hi,

you can loop through all queries

For i = db.QueryDefs.Count - 1 To 0 Step -1
If instr(db.QueryDefs(i).SQL, tablename) >0 Then
'update query SQL by replacing old table name, you can create a
loop for replacing name in case more than once is found
db.QueryDefs(i).SQL =
End If
Next i

Chris

http://www.rickworld.com/

--

AG
Email: npATadhdataDOTcom


"Peter Clements" <user (AT) compgroups (DOT) net/> wrote

Per agiamb:
+1

I've tried a commercial-grade replace utility and it didn't hold
a candle to the RickWorld offering - in speed or convenience.
--
PeteCresswell

On Nov 19, 5:56*am, Peter Clements <u... (AT) compgroups (DOT) net/> wrote:
I use Find&Replace as mentioned by Agiamb and Peter

Peter Clements wrote:
Create a saved query using the original name of the table and have it select
from the renamed table

On Fri, 19 Nov 2010 08:06:21 -0500, "agiamb"
<NOSPAMagiamb (AT) newsgroup (DOT) nospam> wrote:

Fine product!

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/

"(PeteCresswell)" <x@y.Invalid> wrote in
news:d03de61n9nsi77k44dk320gpkc1r26gp4j (AT) 4ax (DOT) com:

I own Rick Fisher's tool, but don't think it comes close to
SpeedFerret, which I used to use quite extensively with A97 (I never
upgraded because by the time I have moved away from A97, the target
was A2003, and SpeedFerret was never upgraded for that,
unfortunately).

The tools that I actually use more than Rick's are:

1. Name Autocorrect -- I kid you not. Keep it off for normal work,
but when you need to do a major renaming, turn it on temporarily,
and turn it back off when you're finished. It works fine if used in
this way.

2. MDBSearch 2.1 (by Ucora and Jamie Bernstein) -- this is no longer
available anywhere on the Internet so far as I can tell, but it's
what I use more because it works very well for what it does.

--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/

On 21 Nov 2010 20:18:20 GMT, "David-W-Fenton" <dfassoc (AT) dfenton (DOT) com>
wrote:

I will occasionally do the same.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/