Subject: RE: [AccessD] db1, 2, 3 ........

Charlotte Foust cfoust at infostatsystems.com
Fri Jul 9 17:30:53 CDT 2004


Starting with 2000, it is possible for the database to be partially
compiled, which has a major effect on performance.  Sometimes you'll
make a change but the Compile option on the Debug menu in VBE will be
grayed out.  I was assuming that the db1 was the compacted copy, but it
may not be.  Since that is the default suggested for any new file, it
could be something else entirely.   When compact and repair can't
complete, it just names its temporary files db1, db2, etc., starting
with the next number after the highest already existing.

Charlotte Foust

-----Original Message-----
From: Pedro Janssen [mailto:pedro at plex.nl] 
Sent: Friday, July 09, 2004 11:12 AM
To: Access Developers discussion and problem solving
Subject: Re: Subject: RE: [AccessD] db1, 2, 3 ........


Hello Charlotte,

wat do you mean by partially compiled state?

When the db1 is a compacted copie of the original, its strange that the
db1 is 74 Mb and the original is 8Mb?

Pedro Janssen


----- Original Message -----
From: "Charlotte Foust" <cfoust at infostatsystems.com>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Friday, July 09, 2004 5:15 PM
Subject: RE: Subject: RE: [AccessD] db1, 2, 3 ........


> The db1.mdb, etc., files are compacted copies of the database that 
> couldn't be renamed, perhaps because the original couldn't be deleted 
> for some reason.  If you're spawning those, then you probably aren't 
> actually compacting your database even though you may think you are.  
> If the database is in a partially compiled state (this is a VBA 
> project issue, not compact and repair), then that might be what is 
> causing the problem.  Try turning off the autocompact and then using 
> the decompile switch to open the database and use the bypass key to 
> avoid running any code. Then close the database, reopen without the 
> decompile switch but using the bypass, and compile and save the VBA 
> project.  Then try turning compact on exit back on and see if that 
> cures the problem.
>
> Charlotte Foust
>
> -----Original Message-----
> From: pedro at plex.nl [mailto:pedro at plex.nl]
> Sent: Friday, July 09, 2004 1:21 AM
> To: AccessD at databaseadvisors.com
> Subject: Subject: RE: [AccessD] db1, 2, 3 ........
>
>
> Hello Charlotte,
>
> i indeed have turned on Compile (compact and repair) after Exit, and 
> indeed its a permissions protected database. So i can delete these 
> db1.mdb etc without any troubles??
>
> Another question: Is compiling after exit a good option, because the 
> fact that in this way the database several times a day wil be 
> compacted.
>
> Pedro Janssen
>
>
>
>
>
> From: "Charlotte Foust" <cfoust at infostatsystems.com>
> To: "Access Developers discussion and problem solving"
> Date: Thu, 8 Jul 2004 14:01:58 -0700
> Subject: RE: [AccessD] db1, 2, 3 ........
>
> Do you have Compile on Exit turned on?  I've usually seen that kind of

> thing when the database attempted to compact but for some reason 
> (often permissions), it couldn't delete the original and rename the 
> db1.mdb, etc.
>
> Charlotte Foust
>
> -----Original Message-----
> From: Pedro Janssen [mailto:pedro at plex.nl]
> Sent: Thursday, July 08, 2004 12:56 PM
> To: AccessD at databaseadvisors.com
> Subject: [AccessD] db1, 2, 3 ........
>
>
> Hello Group,
>
> i have an front & backend mdb on a server. The front-end creates 
> temporary?? databases named as db1.mdb, db2.mdb, db3.mdb etc. each 
> with different filesize.
>
> Why is this and why are these not deleted automatically?
>
> TIA
>
> Pedro Janssen
>
> --
> _______________________________________________
> 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