I have a 230 meg txt file that I append into an empty Access table (Access 2000). The access table has 16 fields, 2 of which are indexed. These two indexed fields plus a third make up the primary key. The append query does no formatting.
I consistently have the following problem (I archive this type of data monthly): I will need to run the append query 6 or more time before it works. The database usually grows to 2+ gigs and the query crashes. I start fresh with a new database and try again, until it finally works. The database grows to 664 megs and compacts to 533 megs.
Why is it that when I append 6 times out of 7 (or so) it grows to 2+ gigs and crashes, while if I keep trying (rebooting to clear memory in between) it will eventually work. I am running a Dell 256 megs of RAM and an Intel PIII with 3.5 gigs of hard drive available.
Any ideas???? Thanks - Paul Paul Faculjak
paul@DataIntegritySolutions.com
I consistently have the following problem (I archive this type of data monthly): I will need to run the append query 6 or more time before it works. The database usually grows to 2+ gigs and the query crashes. I start fresh with a new database and try again, until it finally works. The database grows to 664 megs and compacts to 533 megs.
Why is it that when I append 6 times out of 7 (or so) it grows to 2+ gigs and crashes, while if I keep trying (rebooting to clear memory in between) it will eventually work. I am running a Dell 256 megs of RAM and an Intel PIII with 3.5 gigs of hard drive available.
Any ideas???? Thanks - Paul Paul Faculjak
paul@DataIntegritySolutions.com
