Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

convert an Access 97 database to Access 2003

Discussion in 'Information Technology' started by stickleback, Jul 28, 2006.

  1. stickleback

    stickleback
    Expand Collapse
    Guest

    I had created an database in Access 97 which includes multiple tables and
    forms (no scripts). My computer was recently upgraded and now uses Access
    2003. I thought when I tried to open the existing 97 database in Access 2003
    it would ask me if I wanted to convert it...but it doesn't. It gives the
    message "Can not open a database created with a previous version of your
    application". Any suggestions on how to remedy this?
     
  2. Loading...

    Similar Threads Forum Date
    Sikhconvert Joins Sikh Philosophy Network! New SPN'ers Aug 28, 2016
    Jehovah's Witnesses Are Out And Converting! Blogs Jul 31, 2016
    Islam Ishna Has Converted To Islam Interfaith Dialogues Apr 1, 2016
    A Christian Missionary tried to convert me. Blogs Oct 22, 2015
    "Convert's Corner" - Ideas for Retitle? Convert's Corner Oct 21, 2015

  3. Michael H

    Michael H
    Expand Collapse
    Guest

    Hi.

    I only have Access 2000, so I can't say for sure. However, it seems to me
    you could open just Access itself (without opening any specific database),
    then navagate through the menus to:
    Tools/Database Utilities/Convert Database/To Current Access Database Version.

    Be sure to back up your 97 database before doing this. If it works, please
    let me know.

    -Michael



    "stickleback" wrote:

    > I had created an database in Access 97 which includes multiple tables and
    > forms (no scripts). My computer was recently upgraded and now uses Access
    > 2003. I thought when I tried to open the existing 97 database in Access 2003
    > it would ask me if I wanted to convert it...but it doesn't. It gives the
    > message "Can not open a database created with a previous version of your
    > application". Any suggestions on how to remedy this?
     
  4. david epsom dot com dot au

    david epsom dot com dot au
    Expand Collapse
    Guest

    You need r/w/modify etc permissions on the folder where
    the file is stored. (and also the file has to not be read-only)

    You need Access 'open exclusive' permission on the database.


    I think there is also a registry setting that prevents convert,
    but it's more likely you just have a file or database attribute
    or permission problem

    (david)


    "stickleback" <stickleback@discussions.microsoft.com> wrote in message
    news:4140940F-8491-46F5-8088-1CDD18B1F7F2@microsoft.com...
    >I had created an database in Access 97 which includes multiple tables and
    > forms (no scripts). My computer was recently upgraded and now uses Access
    > 2003. I thought when I tried to open the existing 97 database in Access
    > 2003
    > it would ask me if I wanted to convert it...but it doesn't. It gives the
    > message "Can not open a database created with a previous version of your
    > application". Any suggestions on how to remedy this?
     
  5. stickleback

    stickleback
    Expand Collapse
    Guest

    Hi Michael,
    I tried what you suggested but I ended up with the same message. So maybe
    it doesn't work with Access 97?

    "Michael H" wrote:

    > Hi.
    >
    > I only have Access 2000, so I can't say for sure. However, it seems to me
    > you could open just Access itself (without opening any specific database),
    > then navagate through the menus to:
    > Tools/Database Utilities/Convert Database/To Current Access Database Version.
    >
    > Be sure to back up your 97 database before doing this. If it works, please
    > let me know.
    >
    > -Michael
    >
    >
    >
    > "stickleback" wrote:
    >
    > > I had created an database in Access 97 which includes multiple tables and
    > > forms (no scripts). My computer was recently upgraded and now uses Access
    > > 2003. I thought when I tried to open the existing 97 database in Access 2003
    > > it would ask me if I wanted to convert it...but it doesn't. It gives the
    > > message "Can not open a database created with a previous version of your
    > > application". Any suggestions on how to remedy this?
     
  6. stickleback

    stickleback
    Expand Collapse
    Guest

    Hi David,
    I checked my permission on the database and it appears I have full control.
    So I'm not sure what else I would need? Not sure what you mean by 'open
    exclusive' permission?

    "david epsom dot com dot au" wrote:

    > You need r/w/modify etc permissions on the folder where
    > the file is stored. (and also the file has to not be read-only)
    >
    > You need Access 'open exclusive' permission on the database.
    >
    >
    > I think there is also a registry setting that prevents convert,
    > but it's more likely you just have a file or database attribute
    > or permission problem
    >
    > (david)
    >
    >
    > "stickleback" <stickleback@discussions.microsoft.com> wrote in message
    > news:4140940F-8491-46F5-8088-1CDD18B1F7F2@microsoft.com...
    > >I had created an database in Access 97 which includes multiple tables and
    > > forms (no scripts). My computer was recently upgraded and now uses Access
    > > 2003. I thought when I tried to open the existing 97 database in Access
    > > 2003
    > > it would ask me if I wanted to convert it...but it doesn't. It gives the
    > > message "Can not open a database created with a previous version of your
    > > application". Any suggestions on how to remedy this?

    >
    >
    >
     

Share This Page