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
>
>