I hope someone can help me with this.
I was just contacted by a client that's using an app that uses Access 97 as a back end. The front end app is a compiled application.
Someone on site did "something" and now, when you launch the back end file, the 97 database window is no longer visible. In fact it doesn't even appear as if a database is open. But a lock file is created when you open the file. And the lock file disappears when you close it.
I imported all the data, which did in fact exist, into a new clean 97 database and rename the new table to the name the front end app is looking for. Everything worked fine. Then the user started getting error messages about entry being required. And so we had to go back to the old app. the one with no database window. And their front end works fine.
Holding the shift key down doesn't seem to do anything. F11, F12 nothing.
Any ideas??? It's been a long time since I used 97 and I don't remember the ins and outs.