Changing Oracle ODBC Server

[Brian]

When I change the Oracle ODBC server I use for linked
tables, all of my queries fail trying to use the old
server. I've relinked the tables and I can see the data.
How can I get the queries to recognize the server change?

 

[Joe Fallon]

Not enough detail in your post.

If you have deleted and re-created the linked tables (NOT refreshed!!)
then your Access queries will work fine.

Are you using SPT queries? (SQL Pass Through.)
They store the link to the old db and would need to be changed.

In my re-connect code I use this to change the connection string of my SPT
queries when I link to a new dbODBC.
Set qdf = db.QueryDefs("sptCount")
qdf.Connect = dbODBC.Connect

 

[Joe Fallon]

Yes there is- use the Refresh command.
But it is unreliable when used with ODBC data sources.
(I don;t recall all the minor issues anymore but there are 2-3 of them that
can be more annoying than just deleting and re-creating.

I *always* delete and re-create.
--
Joe Fallon
Access MVP

Is there any way to get the tables to pull the new data, from the new data

source database, without deleting and rebuilding all of them?