weird shapes appeared in my form and a search key message

S

SheriTingle

Hi. Thanks for the help. I am using Access 2000. I have a database that has
been working fine for months. It contains over 800 records. I was on the form
in one of the records updating some data when suddenly all of the field data
changed to vertical lines. I closed the form, opened the table and on the
same record the shapes are squares. No text is left on this record but all
other records are fine.

When I try to delete this record I get a message telling me that the search
key can not be found therefore the record can not be deleted. Any ideas what
the search key is?

I don't need to keep this line, I can re-enter it but I can't delete it in
order to re-enter it. There is a primary key field using the social security
number.

Also, any ideas what the shapes are and where they came from??
 
A

Allen Browne

Simplest way to get rid of the record if a basic compact'n'repair does not
work is to get Access to create another table without the bad record. That's
usually not too difficult as long as you do not refer to the bad record in
your criteria.

More details in the 3rd symptom of this article:
Recovering from Corruption
at:
http://allenbrowne.com/ser-47.html
 
T

Tony Toews

SheriTingle said:
Hi. Thanks for the help. I am using Access 2000. I have a database that has
been working fine for months. It contains over 800 records. I was on the form
in one of the records updating some data when suddenly all of the field data
changed to vertical lines. I closed the form, opened the table and on the
same record the shapes are squares. No text is left on this record but all
other records are fine.

When I try to delete this record I get a message telling me that the search
key can not be found therefore the record can not be deleted. Any ideas what
the search key is?

I don't need to keep this line, I can re-enter it but I can't delete it in
order to re-enter it. There is a primary key field using the social security
number.

Also, any ideas what the shapes are and where they came from??
Click to expand...

The strange text and the search key message are signs of corruption.

For more information on corruption including possible causes,
determining the offending PC, retrieving your data, links, official MS
KB articles and a list of vendors who state they can fix corruption
see the Microsoft Access Corruption FAQ at
http://www.granite.ab.ca/access/corruptmdbs.htm

Also see the Damaged records within tables section in the To retrieve
your data from a Corrupt 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
 
Top