ODBC connection to failed
Posted on 2015-02-20
We have recently moved our files to a newer fileserver with Server 2008 since our last 2003 Server crashed. One of the files is a simple Access database with a Linked Table, however when I try to open the table called "dbo_Finaltable" I get the error "ODBC--connection to 'Awesomedb' failed." then "Microsoft Access can't open the table in Datasheet view." If I hover the mouse over the table I see "ODBC;DSN=Awesomedb;UID=sa;APP=Microsoft Office XP;WSID=ADMIN1;DATABASE=AwesomeDB;TABLE=dbo.Finaltable". I tried to add a user DSN and a System DSN in Data Sources (ODBC) in 32 and 64-bit versions but the same error comes up. What do I need to do to view this database? Thanks in advance!