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 I’m completely stuck?
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.