Database Not Opening in 2007 - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Database Not Opening in 2007

John Valencic

16 months ago

I have a couple databases that I have used for years, but now neither wants to open. When I click on the file "Membership information", the "Record locking" database of "Membership information" appears and the Access program window just spins as if it was searching for the database, then access shuts down (hope I'm explaining this correctly). I have deleted the "Record locking" database and tried again, still nothing. I've tried just about everything including running the setup for Office and select "Repair" and checked with "Chat GPT" to no avail. BTW, both databases are now .mdb, instead of .accdb. Does anyone have an idea of what happened? I am truly at a loss...

	Sami Shamma @Reply 16 months ago
Try to open the database in safe mode

	John Valencic OP @Reply 16 months ago
Thanks for that Sami. Yes, I can open the database in Safe mode, but none of my controls are functional. I can open and close forms and view reports, but I must do so one at a time, not by control buttons.

	Bill Carver @Reply 16 months ago
Can you open the database on a different computer other than the one you're on?

	John Valencic OP @Reply 16 months ago
Bill, Thanks for your reply. Haven't tried that yet. Currently I have backed up all my tables and Queries to a new 2007 database. Hopefully, after our membership drive, I will reinstall office. I am then going to consider rebuilding the database, as there is too much redundant code that needs to be cleaned up.

	John Valencic OP @Reply 16 months ago
Just realized another snafu, when Building an expression in a query there's no problem, but when I attempt modify the expression using the Zoom feature, the database crashes

	John Valencic OP @Reply 16 months ago
I opened the database on my Windows 7 computer that stays offline and never gets updated and now the database works fine. Guess I'll just keep it offline and transfer reports via USB

	Alex Hedley @Reply 16 months ago
Have you tried importing objects from that db into a brand new empty db in the latest version of Access?

	John Valencic OP @Reply 16 months ago
Thanks for that Alex. I may consider a newer version sometime in the near future, but what I'm doing is strictly voluntary and out of my pocket financially.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View