jwcolby
jwcolby at colbyconsulting.com
Sat Jul 10 07:08:32 CDT 2004
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