How can I do a find/replace across all Access queries to change t.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm using Access to link via ODBC to Oracle databases. I have a "template"
with the queries that I need and I want to be able to copy the template,
relink the tables to the new ODBC schema, and then do some kind of
search/replace feature to redo all the queries to point to the new schema,
not the old. I can do this manually, but it is very time consuming and I'm
hoping that I'm just missing some simple way to do this?
Ideas? Help?
Thank you!!
 
There's nothing built in. You could write code to do it (check out the SQL
property of the DAO QueryDef object) or there are at least two third-party
tools you could use, Find and Replace (www.rickworld.com) or SpeedFerret
(www.moshannon.com)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Format DATETIME to Date in query on linked table 4
Access 2010 append query to SQL is very slow 0
Pass thru Query problem - converting from a case /replace in SQL 1
Probable Access 2007 SP2 Error: Query too Complex 0
append and update queries to PostgreSQL backend very slow 6
Query is too complex after install Access 2007 SP 2 !? 25
Query databased Result 5
Queries take FOREVER to run - ??? 3

Back
Top