DB stopped working

[thart21]

Two days before my vacation and my db has died (Access 2000 with WinXP Pro). 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!!

Access 2000 with WinXP Pro

 

[WayneRyan]

thart,

Wait! Don't cancel that vacation.

You can try to Compact/Repair the database.

Or, Create a new, blank DB and import all of your objects into it.

Then (hopefully) after one of those works, have a nice vacation.

Wayne

 

[WayneRyan]

Toni,

Sorry, I guess that I didn't read your post fully.

It is a corruption problem, though ...

The references were grayed out, because you didn't look at them
when you had your code in design view.

What happened when you tried importing all objects? Did it fail
on one of them?

Start a new db, import just the data and proceed (with saves)
one by one through your objects.

Wayne

 

[thart21]

Thanks Wayne,

It did let me import the objects into a new db, but the references were still grayed out-don't remember, but it must be that I wasn't viewing them in design view. Anyway, for some reason, the db started working again last night. It's on a network so perhaps something was wrong there, even though I could open other non-Access files on the same drive. No clue, but for now it is working and I'll just hope it stays that way.

If it happens again I will definitely try your suggestion. Thanks again for all of the help and I will have a good vacation-Disneyworld!