Error 7399 When trying to link an Access database to SqlServer 2K

[SammyBar]

Hi,

I'm trying to add an Access Database as a linked server to an SqlServer 2000
SP4. Both the server and the access database run on the same PC. The Access
database is protected by a Database password. It is no workgroup password
involved.
After a lot of testing with Visual Basic 6 ADO connection strings I reach to
the following string that is able to open the password protected database by
using VB:

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program
Files\AccessDB\mydatabase.mdb;Jet OLEDBatabase Password=xxxx"

But when using this string in the definition of the linked server in the
Enterprise Manager I get the following error when trying to browser the
tables of the linked server:
Error 7399: OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error
OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0'
IDBInitialize::Initialize returned 0x80004005: ].

I tryed both running the SqlServer as local system account and as a Windows
domain account with domain admin priviledges.
I found also the article http://support.microsoft.com/kb/814398 that
describes a similar problem but that solution did not worked for me.

Any hint is welcomed
Thanks in advance
Sammy

 

[John Bell]

Hi Sammy

You may want to check through http://ask.support.microsoft.com/kb/306518/
Have you checked if the dropping the password from the database works?
You may want to see if moving the database and the security database to a
different directory helps.

John