Runtime error suddenly

[hockeylvr]

Two days before my vacation and my db has died. I have it split and residing on a shared drive. When I open it I get the "db is read-only" message, I click OK and I get "Runtime error 2105 You can't go to the specified record", click Debug and it takes me to my code for the form I have set to load when the db is opened and it highlights the line "DoCmd.GoToRecord , , acNewRec.

1) I cannot get into References as it is grayed out
2) I have tried importing all objects into a new db-same issue.
3) I tried to create a new module, unchecking all references, closing the db, reopening and rechecking references, but it would not let me uncheck these two
Visual Basic For Applications and MS Access 9.0 Object Library, stating "can't remove control or reference-in use".
When I try to delete the highlighted code, the VBA window locks the db up completely and I can only Alt-Ctl-Del to get out of it.

As you can see I have tried everything I could find on the forum but nothing works. I would appreciate any help you could give me as I'm getting panicked!!

 

[bubba100]

Try using the Shift-Enter to open the DB. I believe this will bypass any code that runs when you open the DB. Then goto the modules tab and open a new module and check your references. The reason the References are grayed out now is the code is running and "stuck" because of the error.

 

[hockeylvr]

Unfortunately, that is what I did in step 3 above, and it will not allow me to uncheck those 2 references, even when the new module vba window is the only one open and there is nothing in it.

 

[jane2geo]

I got same problem after udating MDAC ver. 2.8
Using "DoCmd.GoToRecord , , acNext". Worked fine
until 2.8 update.