Data Corruption

[Din Zavery]

Hello All,

I'm using Access 2007 and yesterday we had a power failure and the machine
got switched off abrubptly. I was doing data entry on a new record in a
particular table through a form.

On resuming I found that particular records I was entering went into #Error
state ... I mean all Fields in the Form and Table were showing #Error

On trying to delete the record through the Form and Table directly I now get
a #Deleted in all the fields. If I try and click or edit any of those fields
I get error message and going through the help button it says that a Book
Mark does Not exist.

I can't seem to get rid of this particular record and I'm the admin on the
dataase and the machine. If I try and add another record with the same as
the one I was trying I get a Primary Key Error ... meaning that the record
is still there but I can't see it apart from the #Deleted message on each
and every field.

Will appreciate any help in trying to get rid of this error or rectifying my
data.

Thanks and Regards
Din Zavery

 

[Jeff Boyce]

First, make a backup... Make two!

Try opening the application and running the Compact & Repair function.

Did that fix it?

If not, can you create a new (empty) table and copy in all the rows EXCEPT
the bad one?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Din Zavery]

Hello Jeff,

Repair option seems to have done more damage than any good ... I see more
garbage and all my sorting on the form is messed up and not sequential as it
was before.

Good I took a backup first ... will try and recreate a new table and see if
that helps

Thanks and REgards
Din Zavery

 

[Tony Toews [MVP]]

On trying to delete the record through the Form and Table directly I now get
a #Deleted in all the fields. If I try and click or edit any of those fields
I get error message and going through the help button it says that a Book
Mark does Not exist.

See the Corrupt Records in a Microsoft Access MDB page at my website
http://www.granite.ab.ca/access/corruption/corruptrecords.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/