CORRUPTION

[Derek]

Hi and Help

How do you find and eliminate corruption from tables

 

[Daniel Pineault]

Take a look at http://www.granite.ab.ca/access/corruptmdbs.htm
--
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.

 

[Linq Adams via AccessMonster.com]

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

 

[Derek]

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

 

[John W. Vinson]

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.

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.