[AccessD] Swelling database

Dan Waters dwaters at usinternet.com
Thu Apr 3 20:07:59 CDT 2008


The backup might also have the effect of decompile/compile to remove 'old'
code.

Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
Sent: Thursday, April 03, 2008 7:40 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Swelling database

I suspect the "backup" creates a new database and imports everything
into it rather than just doing a compact.  

Charlotte Foust 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Thursday, April 03, 2008 5:15 PM
To: Access Developers discussion and problem solving
Subject: Re: [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
>
--
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