Possible to update ~180 queries with find/replace script or function?

[jeebs]

The company I work for is consolidating regional server space onto a single server. I have relinked all of my tables, but my ~180 queries are still pointing to the old server.



My question: Is there a script or other process that can be executed that will search through all my queries within the database to find the string "dbo_tbl" and replace with "dbo_vwtbl"? I would very much like to avoid taking each individual query to a notepad...

Much thanks for any insight

[John_G]

Hi -

Much easier would be just to rename the linked table back to dbo_tbl in your MS Access database. That does not change the link or rename the table in the external database, it only changes what you call it.

John

[jeebs]

Sometimes the easiest solution is the hardest to see. Thanks John

[ItsMe]

...rename the linked table back to dbo_tbl...

I don't know that I would have thought of that.