Changing Oracle ODBC Server

  • Thread starter Thread starter Brian
  • Start date Start date
B

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?
 
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
 
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



Follow up question said:
Is there any way to get the tables to pull the new data, from the new data
Click to expand...
source database, without deleting and rebuilding all of them?
 
Back
Top