Database Size Expansion

[Douglas Nelson]

The database here is a front & back-end combination that
I've converted from 97 to 2002 (xp). The table is in the
back-end, and the code manipulating it is in the front-end.

I have a table that contains about 73,000 records. I have
a routine that opens a recordset to update between one to
twenty-four fields (based on criteria) with text. In
Access 97 (the previous platform), the back-end would grow
from about 300MB to about 450MB, which would then compact
back down to 300. Now, it grows to a little over 2GB when
it's a little over halfway through (41,000 records) the
records. I understand that 2Gig is the limit, but why is
it bloating so much? How do I work around this or fix it?

 

[Valerie]

Have you used the MS ACCESS Tools in the toolbar of the
database? Go to Tools, Database Utilities, Compact
Database and then Repair Database. Also, I sort -
Ascending/Descending of columns in tables to check data
validity in records, such as dates(obvious error if Date
of Birth is 03032013)etc. Check record before or around
the 41,000th record to see if any record(s)may be corrupt
(ERROR#) or data was not converted correctly.

 

[Douglas Nelson]

Thanks, but that's not it. I compact & repair before the
procedure, and the data is valid. I'm pretty sure it's a
size issue. Just looking for a workaround.

I do appreciate the input, though.

Douglas