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

Pedro Janssen pedro at plex.nl
Tue Jul 13 16:23:12 CDT 2004


Thanks to all that responded on my question.
I wil try all options on test front-ends and i'll hope that they wil
properly be compiled / compacted.

Pedro Janssen




----- Original Message -----
From: "jwcolby" <jwcolby at colbyconsulting.com>
To: "'Access Developers discussion and problem solving'"
<accessd at databaseadvisors.com>
Sent: Saturday, July 10, 2004 2:08 PM
Subject: RE: Subject: RE: [AccessD] db1, 2, 3 ........


> Pedro,
>
> Just remember that if you run a split database, i.e. FE/BE, doing a
compact
> on exit will only compact the FE, not the BE.  Compacting the FE may not
> even be necessary depending on whether you get a new copy daily (as I do)
or
> what you do with the FE.
>
> John W. Colby
> www.ColbyConsulting.com
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of pedro at plex.nl
> Sent: Friday, July 09, 2004 9: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
>
>




More information about the AccessD mailing list