[AccessD] Swelling database

Currently I am using A2k3 and frequently using its "Back Up Database"
option. I also frequently use "Compact" option. What puzzles me is that when
I use the former the db-size goes down from say 4MB to 2MB, but the
"Compact" option leaves the same file as about 4MB rather than the 2MB of
the backed-up version. I don't know why this occurs. What I have learned is
that when I backup Arthur20080404.mdb which is 4MB the result
(Arthur20080404a.mdb) is about half the size. The weird thing is that Access
reloads the current one rather than the backup, but I guess I can live with
that now that I know it. What puzzles me about this all is that "Compact and
Repair" does not compress the file anywhere near as much as "Backup". That
seems very odd to me, but I have done this dozens of times and it is
consistent.

Arthur

On Thu, Apr 3, 2008 at 7:53 PM, Rocky Smolin at Beach Access Software <
rockysmolin at bchacc.com> wrote:

> I still have the Access 2000 Developer's Handbook (Getz, Gilbert, Littwin)
> on my desk and use it frequently. My copy is getting pretty beat up.  It's
> the Bible and has lots of code on a CD that you can cut and paste.
> Everything's in there.
>
> Rocky
>
>
>
>
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Barbara Mende
> Sent: Thursday, April 03, 2008 11:06 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Swelling database
>
> All of the above, although really only one major table/form plus a few
> queries.  Lots of text in memo fields but only nine fields.  Really simple
> and dumb.  I'm learning a lot from you.  (Does anyone know of a good basic
> manual?  I think I've seen them all and they never have what I'm looking
> for.)  Thanks again, B.
>
> ----- Original Message ----
> From: Rocky Smolin at Beach Access Software <rockysmolin at bchacc.com>
> To: Access Developers discussion and problem solving
> <accessd at databaseadvisors.com>
> Sent: Thursday, April 3, 2008 1:33:54 PM
> Subject: Re: [AccessD] Swelling database
>
> Is it just tables in your db or forms/report/queries etc., as well?
>
> Rocky
>
>
>
>
>
>
>
>
> -----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
>
> No virus found in this incoming message.
> Checked by AVG.
> Version: 7.5.519 / Virus Database: 269.22.5/1356 - Release Date: 4/2/2008
> 4:14 PM
>
>
> --
> 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
>
> No virus found in this incoming message.
> Checked by AVG.
> Version: 7.5.519 / Virus Database: 269.22.5/1356 - Release Date: 4/2/2008
> 4:14 PM
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>