corrupted record won't delete

[neenmarie]

I have a record that has 4 boxes in the primary key field instead of the part
number that should be there....it....

Won't allow me to write over this field.
Won't allow me to delete the record.
Won't allow me to remove or change the key in the table.
Won't allow me to use an update query to change the field back to it's part
number
Won't allow me to use a delete query to delete the record.

Although this is the primary key field, it did allow me to put in another
record with the part number that was originally in the corrupted record...But
it does in some way still see the original part number because it attempts to
bring the record up in subforms attached to the main form by the part number.
When this happens it locks up the database.

Any ideas how to get this record out of the system?

 

[John Vinson]

I have a record that has 4 boxes in the primary key field instead of the part
number that should be there....it....

Won't allow me to write over this field.
Won't allow me to delete the record.
Won't allow me to remove or change the key in the table.
Won't allow me to use an update query to change the field back to it's part
number
Won't allow me to use a delete query to delete the record.

Although this is the primary key field, it did allow me to put in another
record with the part number that was originally in the corrupted record...But
it does in some way still see the original part number because it attempts to
bring the record up in subforms attached to the main form by the part number.
When this happens it locks up the database.

Any ideas how to get this record out of the system?

Your database is seriously corrupted, and *this database* is probably
unsalvagable. But the data *in* the database (except for this record)
is probably still OK.

Create a new, empty database; import everything BUT this table. Import
this table *design mode only*, not the data (or you'll just import the
corruption). Now use File... Get External Data... Link to link to the
damaged table and run an Append query to append all the data in good
records to this new empty table. Use one or more range criteria on the
primary key field to explicitly select records with valid primary key
values.

See http://www.granite.ab.ca/access/corruptmdbs.htm for some excellent
resources on corrupt databases and their salvage.

John W. Vinson[MVP]

 

[neenmarie]

Thank you for your help....

Your database is seriously corrupted, and *this database* is probably
unsalvagable. But the data *in* the database (except for this record)
is probably still OK.

Create a new, empty database; import everything BUT this table. Import
this table *design mode only*, not the data (or you'll just import the
corruption). Now use File... Get External Data... Link to link to the
damaged table and run an Append query to append all the data in good
records to this new empty table. Use one or more range criteria on the
primary key field to explicitly select records with valid primary key
values.

See http://www.granite.ab.ca/access/corruptmdbs.htm for some excellent
resources on corrupt databases and their salvage.

John W. Vinson[MVP]