Linked Tables and Two Different Databases on two different servers

[zwheeler]

Hi
I have an Access DB 2003, I have two external databases (1. SQL Server 2008 64 bit) (2. Sybase DB)

I have created two ODBC connections (with Different DSN's, username and password) and I can Link the tables successfully and view data.

Issue:
For some reason whenever i first open up Access and I want to open the tables from SQL Server it gives me an error and shows me the DSN for Sybase DB. After a while i reopen the access DB and then open up the SQL Server table and it works fine.

So it appears as though the Link manager is getting confused about which DSN to use initially.



As you can imagine it is very frustrating, I was wondering if anyone else has experienced a similar problem and what was their solution?

Your assistance is much appreciated in Advance

[ItsMe]

I have not experienced a similar problem, but I would suggest using a form that launches at startup to connect to a small table on each of the two servers. For instance, code behind the form can retrieve a small dataset from the SQL server using a connection string, as well as retrieving a small dataset from the Sybase server.

[NTC]

my only point to add is that you are working with databases that are of different vintage and that can't be ideal. 2008 may have features that 2003 doesn't know about. I would get a trial of a new version of Access and see if the issue persists. Access 2013/2016 will definitely have all Server 2008 parameters...can't speak for Sybase though