I am running into the same problem and would like to know how to get it
to run correctly. I am using SQL Server 2000 sp3. The mdac version on
the web server is 2.7 I am linking one table from sql server into an
Access 2000 Database. There is a query that joins the data from the sql
server table onto some jet tables. Everything runs correctly from within
Access. Only when I try and select * from my access query do I get the
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] ODBC--connection to
I have searched numerous forums and have found this to be a re-occuring
issue but never an answer.
Any help would be appreciated
Posted via http://dbforums.com