I am linking to some Access 97 tables from SQL Server 2005, however, I have had a lot of problems. These are generally sorted out by restarting the SQL server, but after a while it fails again. (queries to XLS files on the same configuration are fine)
If I go to SQL Server Management studio and check the connection to the Access databases, I get a 'Cannot initialise data source object of OLE DB provider' error message. However, if I go to the provider properties for the Jet provider and deselect 'allow
inprocess'. it works. If I reselect it, it fails.
Can anyone help?
View Complete Post