M
Marc Mahoney
I have an Access 97 database that I wish to convert to Access 2000.
Unfortunately it is not a simple task as I wish to convert it using some sort
of utility that requires no user interraction as it to be performed as part
of an SQL Server 2000 Job that runs nightly.
At present, the Access 97 databse is registered as a linked server with SQL
but due to incompatibilities between the two, the Job regularly fails with
the following message :
[SQLSTATE 01000] (Message 17954) OLE DB provider 'Microsoft.Jet.OLEDB.4.0'
reported an error. [SQLSTATE 42000] (Error 7399) [SQLSTATE 01000] (Error
7312) OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0'
IDBInitialize::Initialize returned 0x80004005:]. [SQLSTATE 01000] (Error
7300). The step failed.
At first, we thought it was to do with the SQL Mail profile, but trying to
connect to the Access 97 database through Enterprise Manager returned the
same error. When the database is converted to Access 2000 there are no
errors and everything runs perfectly.
The database contains tables only, no queries etc but it has to be stored in
the 97 format as it is used by some legacy software used within the company.
Our SQL Server is 2000 Enterprise and has all the updates, service packs
etc. Currently running MDAC 2.8.
Does anyone know of any way that this can be done?
Many thanks
Marc
Unfortunately it is not a simple task as I wish to convert it using some sort
of utility that requires no user interraction as it to be performed as part
of an SQL Server 2000 Job that runs nightly.
At present, the Access 97 databse is registered as a linked server with SQL
but due to incompatibilities between the two, the Job regularly fails with
the following message :
[SQLSTATE 01000] (Message 17954) OLE DB provider 'Microsoft.Jet.OLEDB.4.0'
reported an error. [SQLSTATE 42000] (Error 7399) [SQLSTATE 01000] (Error
7312) OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0'
IDBInitialize::Initialize returned 0x80004005:]. [SQLSTATE 01000] (Error
7300). The step failed.
At first, we thought it was to do with the SQL Mail profile, but trying to
connect to the Access 97 database through Enterprise Manager returned the
same error. When the database is converted to Access 2000 there are no
errors and everything runs perfectly.
The database contains tables only, no queries etc but it has to be stored in
the 97 format as it is used by some legacy software used within the company.
Our SQL Server is 2000 Enterprise and has all the updates, service packs
etc. Currently running MDAC 2.8.
Does anyone know of any way that this can be done?
Many thanks
Marc