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

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 OLEDB:Database 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
SammyHi 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
"SammyBar" wrote:

> Hi,
> I'm trying to add an Access Database as a linked server to an SqlServer 20
00
> SP4. Both the server and the access database run on the same PC. The Acces
s
> 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 OLEDB:Database 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 Window
s
> 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
>
>