469,631 Members | 1,798 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,631 developers. It's quick & easy.

Database corrupt by one record

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
Nov 13 '05 #1
3 1431
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.

Nov 13 '05 #2
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?

Nov 13 '05 #3
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
Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

19 posts views Thread by adirat | last post: by
1 post views Thread by Andrew Chanter | last post: by
6 posts views Thread by Gary | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.