Corrupted Record

[Guest]

I have one corrupted record in one table of my database and I tried to fix or
delete it but i retrieve the message: "Disk or network error".
The database don't work properly because of these. I can see all the data,
except this record.
How can i delete it?

 

[John Vinson]

On Tue, 5 Dec 2006 16:06:01 -0800, Marcos Totoli <Marcos

I have one corrupted record in one table of my database and I tried to fix or
delete it but i retrieve the message: "Disk or network error".
The database don't work properly because of these. I can see all the data,
except this record.
How can i delete it?

Check out the suggestions at

http://www.granite.ab.ca/access/corruptmdbs.htm

You may need to create a new database, import everything BUT this
table; import this table, design view only; link to the damaged table;
run an Append query using criteria on the Primary Key to select all
records except this one; reestablish relationships if need be.
Hopefully it can be done more simply!

John W. Vinson[MVP]

 

[Alan]

Hi John Vinson,

You can try our product Advanced Access Repair to fix your Access
database. It is a powerful tool that can recover the structure and
records of the tables in Access databases.

Please visit http://www.datanumen.com/aar/index.htm for detailed
information about Advanced Access Repair.

And you can also download a free demo version at
http://www.datanumen.com/aar/aar.exe

Alan Chen
DataNumen, Inc. - World leader in data recovery technologies
Website: http://www.datanumen.com
Fax: +1-800-9917-FAX (US Toll-Free), +852-31829286 (HONG KONG)

 

[Alan]

Hi Marcos,

You can try our product Advanced Access Repair to fix your Access
database. It is a powerful tool that can recover the structure and
records of the tables in Access databases.

Please visit http://www.datanumen.com/aar/index.htm for detailed
information about Advanced Access Repair.

And you can also download a free demo version at
http://www.datanumen.com/aar/aar.exe

Alan Chen
DataNumen, Inc. - World leader in data recovery technologies
Website: http://www.datanumen.com
Fax: +1-800-9917-FAX (US Toll-Free), +852-31829286 (HONG KONG)

 

[Alan]

Hi Marcos,

You can try our product Advanced Access Repair to fix your Access
database. It is a powerful tool that can recover the structure and
records of the tables in Access databases.

Please visit http://www.datanumen.com/aar/index.htm for detailed
information about Advanced Access Repair.

And you can also download a free demo version at
http://www.datanumen.com/aar/aar.exe

Alan Chen
DataNumen, Inc. - World leader in data recovery technologies
Website: http://www.datanumen.com
Fax: +1-800-9917-FAX (US Toll-Free), +852-31829286 (HONG KONG)

 

[Tony Toews]

I have one corrupted record in one table of my database and I tried to fix or
delete it but i retrieve the message: "Disk or network error".
The database don't work properly because of these. I can see all the data,
except this record.
How can i delete it?

The "Disk or network error" message usually happens when there is a
flaky network connection of some sort. Now this can lead to
corruptions such as the bad record you state.

To fix the bad record see
http://www.granite.ab.ca/access/corruption/corruptrecords.htm.

For some suggestions on figuring out the Disk or Network Error see
http://www.granite.ab.ca/access/corruption/causes.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm