Help with Corrupt db Please

  • Thread starter Thread starter Noel
  • Start date Start date
N

Noel

Hi. Ive just had a database corruption and I wonder if
anyone has any ideas on how to recover from this, rather
than revert to the last backup. I was in the process of
renaming a Form and I got a corruption message. It said I
should compact and repair to correct the problem but doing
this simply causes the message to repeat. If I repeatedly
click the messages OK button, I eventually get a different
message saying that the Form I tried to open doesn’t exist
or has been renamed. This is the last Form I was trying to
rename. I would appear that part of the db thinks this
Form exists while another does not. When I click OK on
this, it reverts to the original message. Eventually,
after much clicking on OK, I can open the db but the
minute I try any activity, including trying to delete,
rename or create a Form, I get the same error message.
Curiously, though, it will allow me to look at objects in
design view. Has anyone any ideas about how to get out of
this? I thought of copying the tables to a backup but it
wont let me do anything. Any help would be appreciated.
Thanks, Noel
 
Thanks Mark but as I said, thats just one of the things it
wont let me do. Any other idea? Thanks Noel. P.S Ill
repost this in General questions, where I thought Id
posted this.
 
Noel

One other thing comes to mind. Rename the old db, create
a new db, import all the objects to the new db (except the
last form) do a compact/repair.

Good luck.

Mark
 
Thanks again Mark The problem is I cant export from or
import to the corrupt database. Otherwise, you are
correct, I could just export/import all the good objects
to a new db. Ive even downloaded a different compact and
repair exe file but that doesnt fix the problem either.
Its pretty clear to me now that the db thinks there is a
form called frmOffersUsedYr1, even though its not showing
in the list of forms. I cant create this form, or rename
existing ones, so Im stuffed. Thanks for the help.
Cheers, Noel
 
Have you tried saving a blank form as frmOffersUsedYr1 and
see if that will fix the db

Jim
 
Noel

Check to see if the form has been hidden by going under
Tools/Options and selecting the Hidden Objects box. Maybe
that's why you can't see the problem form.

Mark
 
Back
Top