Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2008

    Unanswered: Opening Access 97 DB in Access 2003 - Does Not Show Changes Made

    I have an Access database which i created in Access 97 and up until now has always been opened in Access 97.

    The Company this database is for has upgraded some of their machines to Office 2003. When the Database is opened in office 2003 the changes made to the database (which have been made in Access 97) do not show up, they stay the same as before.

    When the database is loaded in Access 97, the changes are visible.

    Can anyone help me with my problem as Im completely stuck?


    Mike Gatward

  2. #2
    Join Date
    Apr 2004
    metro Detroit
    What kind of changes?

  3. #3
    Join Date
    Apr 2008
    Various updates were made including layout and additional fields. These changes do not appear on 2003 but do appear on 97.

  4. #4
    Join Date
    Nov 2007
    Adelaide, South Australia
    I'd be guessing that there is a 2003 version and a 97 version and you have to re-create the 2003 version.

    I say this because 2003 can't cleanly open a 97 format file (it will offer the user the option of upgrading it) and because the symptom described is unlikely to be a development issue.... every time I have run into any problem like that it has always been a multiple instances issue.

    You could try decompiling, compacting and compiling to clean it up I guess, but I'm not convinced that this is a development issue.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!

    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts