Access 97 Verses Access 2002 (XP)

[Ross]

I run an Access 97 program which I developed and I have
no problems. I convert it to XP Version 2002 and import
about 370,000 records. The size of the database will
grow to 2,097,152 mg and the database will destroy
(corrupt)itself.

Record pull is a two step process. If I compact after
step 1, I can complete step 2 without a crash but it
still grows exponentially! What is happening?

Thanks

Ross