Strange symbols on form/ Error message

D

David

I have a form I use to Add/Edit Inventory. I access it by part number, but
one particular part number has strange symbols in most of the fields, the
rest have incorrect information, such as a retail for $64,852,164,489,301.27
instead of $39.97 and a Last Update date of 12/30/1899 instead of today. I
have tried to edit the fields and get a "The search key was not found in any
record" message. I can't delete it either. The PrimaryKey is the part #
which has unknown symbols in it , but will still bring up this record when I
type in the actual part number, so it is all there somewhere. I have tried a
Compact and repair. Any other ideas?

Thank You!
 
J

John W. Vinson

I have a form I use to Add/Edit Inventory. I access it by part number, but
one particular part number has strange symbols in most of the fields, the
rest have incorrect information, such as a retail for $64,852,164,489,301.27
instead of $39.97 and a Last Update date of 12/30/1899 instead of today. I
have tried to edit the fields and get a "The search key was not found in any
record" message. I can't delete it either. The PrimaryKey is the part #
which has unknown symbols in it , but will still bring up this record when I
type in the actual part number, so it is all there somewhere. I have tried a
Compact and repair. Any other ideas?

Thank You!
Click to expand...

This record is corrupt and your database is at risk!

Create a new database - and all new .mdb file.

Import all of the objects from this database, *except* for this table.
Import this table, selecting the option "design only" to get an empty table.
Use File... Get External Data... Link from the new database to link to the
damaged one.
Create an Append query based on the liked (old, damaged) table. Use some
criteria that select all records EXCEPT the damaged one - don't "touch" that
record at all, even in the criteria. For instance, if you have an autonumber
field and it's record 3145, use a criterion of

<= 3144 OR >= 3146

on that field. You may be able to do the same with your part number.

This record will need to be manually reentered, and the old database
discarded.

See http://www.granite.ab.ca/access/corruptmdbs.htm for more description of
database corruption.

John W. Vinson [MVP]
 
D

David

John W. Vinson said:
This record is corrupt and your database is at risk!

Create a new database - and all new .mdb file.

Import all of the objects from this database, *except* for this table.
Import this table, selecting the option "design only" to get an empty table.
Use File... Get External Data... Link from the new database to link to the
damaged one.
Create an Append query based on the liked (old, damaged) table. Use some
criteria that select all records EXCEPT the damaged one - don't "touch" that
record at all, even in the criteria. For instance, if you have an autonumber
field and it's record 3145, use a criterion of

<= 3144 OR >= 3146

on that field. You may be able to do the same with your part number.

This record will need to be manually reentered, and the old database
discarded.

See http://www.granite.ab.ca/access/corruptmdbs.htm for more description of
database corruption.

John W. Vinson [MVP]
Thanks for the help and your speedy response. I will get on it before we end up starting from scratch!
Click to expand...
 
Top