[AccessD] Compression slows down MDB

Edward Zuris edzedz at comcast.net
Fri Jan 27 11:11:08 CST 2012


 
 Looking at MSFT's web site I get the impression
 that repair and compression of your MDB file is
 a good thing.
 
 However. . .
 
 Has anyone had the experience of doing a compress
 and your MsAccess application slowed way down ?
 
 At 170 megabytes in size, it takes 31 minutes to do
 a days worth of updates.  At 850 megabytes it takes
 just 8 minutes.
 
 BTW, this happens on W2K 32bit Pro with Office 2000,
 and Win-7 64bit Pro, using Access 2003 32bit, using
 access 2000 file structures.
 
 The application didn't change that behavior when
 converting every thing over to Access 2003 file
 structures.
 
 Any ideas ?
 
 Thanks.
 
 Sincerely,
 Ed Zuris.
 
 


More information about the AccessD mailing list