Convert Access 97 to Access 2000

[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

 

[Albert D. Kallal]

Well, here is possible suggestion:

Create a 2000 mdb file..but LINK the tables to the a97.

Now, just work with the a2000 mdb....it might work...

 

[david epsom dot com dot au]

same error. When the database is converted to Access 2000 there are no

errors and everything runs perfectly.

This PROBABLY means that it was fixed by importing all the objects into
a new database. You can do that without converting to Access 2000.

You can use a .VBS script to convert the database from Jet 3.5 to
Jet 4.0. Create a (dao.36) dao.dbEngine object and use it the
compactdatabase method:

dbe.CompactDatabase "OldName", "NewName",
";LANGID=0x0409;CP=1252;COUNTRY=0",64

(david)

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