Database not opening

[sara82]

Hello,

I have been working on a database back and forth and home and at work. Today I saved my database from home and onto my computer at work. The database is not opening here at work. It works fine at home. When I attempt to open it, it tells me Access has encountered a problem and needs to close and it closes.

I tried the Compact and Repair.. Access still shuts down on me. I made a new empted database and tried to import the tables and forms into it.. Access still shuts down on me.

It's getting frustrating because I've been trying to get this working for 3 hours now with no success.

 

[RuralGuy]

Will it open when you hold down a <SHIFT> key?

 

[sara82]

I did as you suggested. I held down the shift key will trying to open the db and it did open but if I click on anything.. forms, tables etc. it tells me that access encountered a problem and it shuts down.

 

[RuralGuy]

Good. Make a backup and then follow all of the suggestions here: http://allenbrowne.com/ser-47.html

 

[sara82]

Thanks it worked! Finally after struggling with it all day.

When I created the new database I truned off the Name AutoCorrect check boxes under: Tools | Options | General as instructed on the website and that is what seemed work for me. It imported it once I did that.

Thanks again!

 

[RuralGuy]

That's great news! Glad I could help.