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

24 Nov 2006 7:24 PM

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 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
Sammy

24 Nov 2006 8:11 PM

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

Show quoteHide quote

"SammyBar" wrote:

> 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
> Sammy
>
>
>