CORRUPTION

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Derek - 06 May 2008 22:38 GMT

Hi and Help

How do you find and eliminate corruption from tables

Reply to this Message

Daniel Pineault - 07 May 2008 02:28 GMT

Take a look at http://www.granite.ab.ca/access/corruptmdbs.htm

Signature

Hope this helps,

Daniel Pineault
For Access Tips and Examples: http://www.cardaconsultants.com/en/msaccess.php
If this post was helpful, please rate it by using the vote buttons.

> Hi and Help
>
> How do you find and eliminate corruption from tables

Reply to this Message

Linq Adams - 07 May 2008 05:08 GMT

And a couple more:

Recovering from corruption
http://allenbrowne.com/recover.html

Symptoms of corruption
http://www.granite.ab.ca/access/corruption/symptoms.htm

Preventing Corruption
http://allenbrowne.com/ser-25.html

Signature

There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Reply to this Message

Derek - 10 May 2008 13:49 GMT

Hi

Thank you all, spent some time on this (2 days)

The problem seem to eminate from the fact that it took 6 years to achieve a
enough data to get a 5Meg data file and two weeks to jump to 15Meg.
All help has been tried but file is same size. I even made an mde file
thinking that would help but even as this it still seems too large.

I saved the file to txt format but as I have referencial integrity on an
autonumber field when I import the text file I cannot set the field back to
autonumber as it is not allowed.

Any ideas?

thanks

> And a couple more:
>
[quoted text clipped - 6 lines]
> Preventing Corruption
> http://allenbrowne.com/ser-25.html

Reply to this Message

John W. Vinson - 10 May 2008 19:01 GMT

>Hi
>
[quoted text clipped - 4 lines]
>All help has been tried but file is same size. I even made an mde file
>thinking that would help but even as this it still seems too large.

15 MByte is NOT THAT BIG. 1500MByte is getting pretty large.

Did you add a picture, either to a form or report or as data? Access (versions
prior to 2007) handles picture data very inefficiently.

>I saved the file to txt format but as I have referencial integrity on an
>autonumber field when I import the text file I cannot set the field back to
>autonumber as it is not allowed.

Create the table, empty, in a new database, with referential integrity and the
autonumber field set. Use File... Get External Data... Link, and select "txt"
from Files of Type; and run an Append query to copy the data into the new
table. If you include the autonumber field in the append, it will faithfully
copy in the existing values and not increment the autonumber.

Signature

John W. Vinson [MVP]

Reply to this Message