If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
corrupted record won't delete
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? |
#2
|
|||
|
|||
On Sun, 9 Jan 2005 07:05:02 -0800, neenmarie
wrote: 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] |
#3
|
|||
|
|||
Thank you for your help....
"John Vinson" wrote: On Sun, 9 Jan 2005 07:05:02 -0800, neenmarie wrote: 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] |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Prevent Blank Records being written. Need Help. | Robert Nusz @ DPS | Using Forms | 4 | December 29th, 2004 05:15 PM |
DELETE query error message | HeatherD25 | Running & Setting Up Queries | 10 | October 23rd, 2004 08:26 PM |
Default message coming up when I try to delete a record in a form | Larnoc | New Users | 4 | August 8th, 2004 11:33 PM |
need to delete record having two different fields with same identical value | L. T. Portella | New Users | 3 | May 14th, 2004 05:49 AM |