[AccessD] Swelling database

Charlotte Foust cfoust at infostatsystems.com
Thu Apr 3 12:38:07 CDT 2008


Access 2000 or 2002 file format?  There's an extra system table in 2002
format that doesn't shrink when you compact. 

Charlotte Foust

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

Access 2002.  Windows XP.  And yes, there are long memo fields but there
always were.  I use the form for data entry.  But I compact it every
day.  Thanks, everyone!


----- Original Message ----
From: Charlotte Foust <cfoust at infostatsystems.com>
To: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
Sent: Thursday, April 3, 2008 1:01:42 PM
Subject: Re: [AccessD] Swelling database

What version of Access and what file format?

Charlotte Foust 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Barbara Mende
Sent: Thursday, April 03, 2008 9:45 AM
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

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
--
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