Database corrupt by one record

[\Jane higgs via AccessMonster.com\]

I have a database that gives me an error message everytime I get to a certain
record. I tried going into the table and deleting that record, but it still
errors out. I get the "Microsoft Office Access has encountered a problem and
needs to close".

When I go to the corrupt record, it has crazy characters in it.

Is there anyway I can get to this record?

Thanks in advance.

--
Message posted via http://www.accessmonster.com

[jv]

First make a backup and then repair and compact. If that doesnt work,
then do a search in the group for database corruption. There are many
existing threads on subject.

Good Luck.

[Allen Browne]

Hi Jane

You can resolve this by creating an empty table and importing all the other
records. The trick is not to refer to the bad record.

Steps explained in the 3rd symptom in this article:
Recovering from Corruption
at:
http://allenbrowne.com/ser-47.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

""Jane higgs via AccessMonster.com"" <fo***@AccessMonster.com> wrote in
message
news:50***********@AccessMonster.com...

I have a database that gives me an error message everytime I get to a
certain
record. I tried going into the table and deleting that record, but it
still
errors out. I get the "Microsoft Office Access has encountered a problem
and
needs to close".

When I go to the corrupt record, it has crazy characters in it.

Is there anyway I can get to this record?

[Alx]

"Jane higgs via AccessMonster.com" wrote:

I have a database that gives me an error message everytime I get to a certain
record. I tried going into the table and deleting that record, but it still
errors out. I get the "Microsoft Office Access has encountered a problem and
needs to close".

When I go to the corrupt record, it has crazy characters in it.

Is there anyway I can get to this record?

Thanks in advance.

I got the same problem occasionally. Have no idea of the cause, and I
was never able to recover the lost data. Compacting the database made me
able to access the record again, but the data... gone...

Alx