[AccessD] Swelling database

Max Wanadoo max.wanadoo at gmail.com
Thu Apr 3 12:15:47 CDT 2008


If any of them are memo fields then you will have to periodically compact
it. I have posted on memo fields before but basically Access does not
overwrite (for speed reasons) but adds to the end so the grow and grow on
each edit.

Max
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Barbara Mende
Sent: Thursday, April 03, 2008 5:45 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Swelling database

My little database had 575 text entries and was 968 KB in size this morning.
I added 50 text entries that were like the others, compacted it, and it had
grown to 1924 KB!  I had added some query forms but removed them.  Is
something seriously wrong?  What should I do about it?

Thanks!
Barbara

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list