search key not found

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

BIG MISTAKE, I had two forms opened that were related to a table, and didn't
save to clipboard, instead....now I have a record in my table and all linking
forms with "jibberish", and I can not delete the record to save my life. I
keep getting the "search key not found for this record". And to make matters
worse, in trying to solve my problem, I created another problem ....was that
I changed my primery key with was an auto number to "text" and lo and behold
I cant change it back!! Can you tell I'm a beginner in Access??
Any suggestions would be GREATLY appreciated.
thanks
renee
 
Firstly, make a backup of your mdb while Access is not running and without
overwriting any previous backups.

Next, make a query into the problem table, and set the criteria to exclude
the problem record. You have to fool Access into not reading the problem
record. For example, if the problem record is number 26, then you would want
criteria of:
<=25 Or >=27

You have a problem here because you have turned your p.k. into text. If you
cannot get this to work, you could try adding another field to the table, so
you do have an autonumber to work with.

If you can get the query working so it shows everything except the problem
record, turn it into a Make Table query (Make Table on Query menu). This
creates a copy of your original table, without the problem record.

More information on recovering from corruption:
http://members.iinet.net.au/~allenbrowne/ser-47.html
 
Back
Top