Converting database from Access 97 to 2003: problems

From: PatrickO (patricko_at_wanadoo.nl)
Date: 05/16/04


Date: Sun, 16 May 2021 22:37:45 +0200

Hi,

I am trying to convert an Access 97 database to Access 2003.

I am using a workgroup file to secure the database.

I have split the database in a front end and a backend. The backend only
contains tables.
Both databases give problems when trying to convert to an Access 2003.

I am describing the conversion of the frontend database.

The problem is that i cannot open the tables.
This message appears:

Reserved error (-1104); there is no message for this error.

Explanation of the steps i did.

First thing that i did is: started Access 2003 and selected the correct
Access 97 workgroup file with Tools, Security, Workgroup Administrator.
Then i want to convert the Access 97 database into a Access 2003 database.
This is how i do this: in the Tools menu i select the Database Utilities,
Convert Database, To Access 2002 - 2003 File Format.
I select the database (Access 97) to convert from and press Convert. Then
give a new name for the new 2003 database and press Save.
This is what appears on screen:

"There were compilation error during the conversion or enabling of this
database.
This might be due to old DAO syntax that is no longer supported.
For an example on how to fixup the code, click Help."

I use DAO in the code.

I pressed Help to see what is told about DAO.
But nothing abot DAO appeared. So i pressed the OK button.
Then the next message appeared:

"The database has not been saved in a compiled state. The performance of
this database will be impaired because Microsoft Office Access will need to
recompile the database for each session.
For information or improving performance, click Help."

I pressed the OK button.

Then the next message appeared:
"Microsoft Office Access encountered one or more errors during conversion.
To view a summary of these errors, open the 'Conversion Errors' table."

I pressed the OK button. A message about sharing pops up. Pressed the OK
button again.

Access 2003 is still open and i open the converted database.
The next message appeared:

Security warning
This file may not be safe if it contains code that was intended to harm your
computer. Do you want to open this file or cancel the operation.

I pressed the Open button. The database is open now.
I would like to see what is in the table 'Conversion Errors'. I select the
table 'Conversion Errors' and press Open to open the table.
This message appears:

Reserved error (-1104); there is no message for this error.

I the try to open a linked table in this database which normally would open
because the link was correct in the Access 97 database.

This message appears:

Reserved error (-1104); there is no message for this error.

One of the tables that is not linked produces the same error when i try to
open it.

All the rest of the objects (Queries, Forms, Reports, Macro's and Modules)
open normally without any problems.

Does any one of you know what is wrong here.

Thanks