Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Linked server between Access 97 and SQL2K5

Author  Topic 

rajkumarrai_bis
Yak Posting Veteran

78 Posts

Posted - 2007-10-16 : 19:33:21
I am trying to create a Linked server between Access 97 and SQL2K5
provider=Microsoft.Jet.OLEDB.4.0
MDAC version installed on SQL server system is 2.8

with same configuration if i convert MDB file to Office 2000 then its working fine
Please advice

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-10-18 : 23:25:07
What's your problem then? Did you get any error? Tried create linked server with odbc provider?
Go to Top of Page
   

- Advertisement -