CORRUPTION

  • Thread starter Thread starter Derek
  • Start date Start date
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
 
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.
Click to expand...

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.
Click to expand...

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.
 
Back
Top