Last night whilst working on my database, I made some changes to the layout of the switchboard. Closed the form and then closed access. I tried to reopen the database to see the changes I made. But instead I get the following screen.

http://i15.photobucket.com/albums/a371/filthy_phil/appcrash.jpg

Once this has happened Access creates but does not delete the lock file. Simply deleting the lock file does nothing. It also creates a backup of the database which also does not open, and also leaves a lock file.

Anyone know of a tool I can use to check the validity of the database, or be able to drag as much data out of it as possible. I am away from my backups and really need to get this going.

Probably important to know the database has a .mdb extension and the lock file .ldb. and I use Access 2007.

The app works as it happily opens other databases.

Start Access2007, open a new database and try to import all objects from the corrupt database. Perhaps it works. If not, it was nice meeting you:D

Start Access2007, open a new database and try to import all objects from the corrupt database. Perhaps it works. If not, it was nice meeting you:D

It was the Swithboard I broke. I managed to figure out I could open the database by holding down the shift key. Then just got rid of the switch board.

Wow!
Your description really got me off track!!

I've never been so far from the solution!

Glad u found it.

I would take this as a lesson and make sure you back up your db before working on design changes.