Search Key Not Found?

[bhaycox]

Hi,

I have a simple one table database which I made a few weeks ago to print letters. All was working ok until I hit record #14, I enter the client details and when I quit the database an error message appears saying 'The search key was not found in any record.' with an option to hit OK or Help buttons. If I hit OK another message box appears saying 'You can't save this record at this time.' and stating that Access has encountered an error & if I close the database I will loose any changes etc...

If I do close it, most of the data I have entered turns to chinese characters & the rest doesn't even ressemble anything close to what I have inputted.
Strangely enough records #15 & 16 work ok and the error only seems to be when I alter the data in the postcode field on record #14

Any assistance would be gratefully received

Ben

 

[boblarson]

That would be a corrupt record. Do TOOLS > DATABASE TOOLS > COMPACT AND REPAIR and then after it reopens go to the record and delete it.

 

[bhaycox]

Sorted!


Cheers Bob

 

[Pooh]

Hi, I have this same problem only mine causes a great deal of grief. I have a simple database set up to monitor quotes into and out of our office. When we get this problem it throws everyone out and all hell lets loose (ok not the end of the world but you know what I mean). They all get angry with me and want to know why it happens. It happens infrequently, around once every three weeks or so, is there anything I can do to stop it or anything that usually triggers it?

 

[gemma-the-husky]

pooh, it sounds like you have not split your dbs properly, and given each user a separate copy of the front end. That will certainly make it more resilieint

 

[Pooh]

Ok, not sure how I would do that (I am a real novice) but that certainly gives me something to look up.

Many thanks for your help

 

[boblarson]

Also, you can implement record level locking (set it on the forms you need, it's in the form properties). I have a client who had the same problem - every so often someone would start editing the same records that someone else was in and then - boom - corrupt record and we would have to go there and fix it. So, I implemented record level locking and, so far, no problems. Just make sure you let people know that if they keep the database open and they are on a record, it will lock anyone else out from making changes.

 

[Pooh]

Thanks Bob, that does sound like something even I can manage!

Many thanks