A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

corrupted record won't delete



 
 
Thread Tools Display Modes
  #1  
Old January 9th, 2005, 04:05 PM
neenmarie
external usenet poster
 
Posts: n/a
Default 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  
Old January 10th, 2005, 01:28 AM
John Vinson
external usenet poster
 
Posts: n/a
Default

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  
Old January 12th, 2005, 03:29 PM
neenmarie
external usenet poster
 
Posts: n/a
Default

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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 06: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


All times are GMT +1. The time now is 07:01 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.