Re: Converting database from Access 97 to 2003: problems

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

  • Next message: Gary A. Hollenbeck: "Re: The database is in an unexpected state; Microsoft Access can't open it." 
    Date: Wed, 19 May 2004 22:30:19 +0200

    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

    "PatrickO" <patricko@wanadoo.nl> wrote in message
    news:40a7d0c2$0$12751$4a441750@news.euronet.nl...
    > 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
    >
    >

  • Next message: Gary A. Hollenbeck: "Re: The database is in an unexpected state; Microsoft Access can't open it."