I have an Access97 secured database which I was able to open in Access 2000 and Access 2002 (Office XP). Using a client's workstation that is running Access97, I made a minor change to a form (adding a Me.Undo statement whening exiting the form). Also, besides adding the Me.Undo statement, I added the following code
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
prior to the closing the form command.
Compiled the module, saved the form, and exited the database.
Users running Access97 don't have a problem, but users running Access 2000 or 2002, see following message:
To convert or enable a database, ensure the following:
* You must join the workgroup that defines the user accounts used to access the database.
Yada, Yada, Yada.
In other postings, the suggestion was to convert the database to the 2000 or 2002. This cannot be done at this time since most of the users are still running Access97, so I don't believe this to be a valid solution. AND, I was able to open this database in the past with no problem, including this morning! How can making a minor change in a form cause this problem?
I don't believe that entering the Me.Undo command caused the problem as after I created the command, I opened the database with Access2002 and was able to test this. But after adding the DoCmd.....acSaveRecord, that was when I was no longer able to open the database.
I have since then removed this entry, but I am still unable to open the database. I even went so far as to create the shortcut that logs me into the database with the workgroup file and still, no access.
Please note that any changes that are made are always made using the Access97 client.
Any suggestions on what I might have missed? Thanks.