Confused

[Mattymatt79]

Last week, when entering information to my database that is finally working PERFECTLY thanks to all the help ive gotten here,
it all of a sudden made this really strange entry on my main table
and whenever i goto delete it says search key not found in any record,
the entry is strange im saying boxes and random charecters and stuff
its wierd, is there any way to get rid of it or anything like that?
it filled all the fields on the form so if i could find a way to get rid itd be great
thanks again guys

 

[Fuga]

This sounds like something I don´t understand.

Whenever I encounter such things, I repair the db

Fuga.

 

[Mattymatt79]

Tried that already still to no avail

 

[Rowena]

It sounds like a record has become corrupted. This has happened to me a LOT. If you can, go into the table where the record is stored and try to delete it. If not, you will probably have to do something more drastic.

I had to split my database, and I back up the back end at least once a day (sometimes every few records, if the network is particularly spotty.) If I have a corrupted record, and Access will not allow me to delete it, I open the backup copy (after saving a backup of it), and copy the good records from the "bad" database until I have reached the bad record. It is possible to copy and paste records in Access, which makes the process a bit less painful. Anyway, the corrupt record has to be re-entered from scratch, but it's better than re-doing the entire thing!

If you haven't got a backup to work from, you may have to create a blank database, and paste the good data from your old database into it. Then make sure you always have a backup in case this happens again.

I hope this is helpful to you!

(and if any of you nice people out there have an easier method of doing this, PLEASE let me know! Thanks! )

Rowena

 

[The_Doc_Man]

If you had an autonumber field in the record as a prime key, you might try to delete the record by its key.

Otherwise, I might try to export the table to a spreadsheet, then delete the offending row, then re-import the table from the spreadsheet.

Or perhaps try to do an append query to a second table that looks the same as the first one (because it is a copy-n-paste, structure only). Try to put a constraint on the append based on one of the rows that seems to be way outside of your normal table constraints.

Then, with a little bit of luck you can erase the original table and reverse the append operation to bring in the stuff you copied earlier.

I would make a backup copy of the DB file somewhere before trying anything that would involve deleting the contents of the original table. I'm not saying you are fumble-fingered. I'm saying we are ALL fumble-fingered 'specially including myself. So it is simply prudent practise to make copies before serious surgery on your database.

 

[Mattymatt79]

I have a backup but its from wednesday of last week, prior to the offending error, so thats good
I also noticed one thing else today, that one of my relationships which was a one to many with referential integrity has been reduced to just a one to one, and when I try to make it back i get that lame error message saying that its too complex or something along those lines, any reason why this happened?
my database is going to crap