Converting database from Access 97 to 2003: problems

[PatrickO]

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

 

[PatrickO]

To all of you who might be interested,

After days of searching the internet, reading newsgroups and whitepapers and
testing i completed the conversion of the secured Access 97 database into an
Access 2003 format.

Although the owner of the database had all the rights the conversion was not
successfull.

I solved this problem by changing the rights of the Admin user:
- placed the Admin user in the Admins group (Admins group has Administrator
Permissions for all objects)
- set Administrator Permissions for the user Admin on all objects (this one
might not be nessecary because the Admin is placed in the Admins group)
- cleared the Admin password (needed for creating a new database with the
Admin as new owner)
- set the New Owner to be the Admin for all objects in the window User and
Group Permissions (might not be nessecary too)

I closed Access 97 and opened Access 97 again.
I then created a new database. Then the Admin user is the current owner.
Then imported all the objects. Then closed Access 97.

I opened Access 2003 with the default system.mdw file (not the secured mdw
file used with Access 97).
I then converted the new Access 97 database with the imported objects in it
succesfully.


I hope this help others with a similar problem.

Greetings Patrick