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!!
 
Back
Top