Access 2003 bloating

[Chucklez]

I created a mdb in Access 2000 that we use for data conversions/manipulations
etc. When we run this in 2000, I can run the entire process without hitting
the 2GB size limit as long as the number of records do not exceed around
350,000 (individual records are very large).

Here at work i recently inherited a newly used pc with Office 2003 (keeping
up with the times) and when i try to run the same program, it quickly gains
size and in no time reaches the 2 gig size limit. Even if I put in 100,000
records at a time, it still bloats up and hits the size limit.

Anyway to solve this? Fixes? Or do I need to regress to Office2000?

 

[Larry Linson]

Anyway to solve this? Fixes? Or do I need to regress to Office2000?

My usual reference re: bloating, multiuser, and avoiding corruption is MVP
Tony Toews' site at http://www.granite.ab.ca/accsmstr.htm. There are several
other excellent resource sites listed in my Resources List at
http://sp.ntpcug.org/accesssig/default.aspx, and there are many, many that I
do not have listed there.

Larry Linson
Microsoft Access MVP

 

[Tony Toews [MVP]]

I created a mdb in Access 2000 that we use for data conversions/manipulations
etc. When we run this in 2000, I can run the entire process without hitting
the 2GB size limit as long as the number of records do not exceed around
350,000 (individual records are very large).

Here at work i recently inherited a newly used pc with Office 2003 (keeping
up with the times) and when i try to run the same program, it quickly gains
size and in no time reaches the 2 gig size limit. Even if I put in 100,000
records at a time, it still bloats up and hits the size limit.

I would think either the Jet version is different or at the office
there are other users in the MDB. You can check the Jet version by
viewing the version number of msjet40.dll in \windows\system32.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/