Rocky Smolin - Beach Access Software
bchacc at san.rr.com
Thu Apr 3 10:10:55 CST 2003
Gustav: There must be something connected to the BE that I'm not aware of. The form which is doing the backup is not bound to the BE (form has no record source). There are no recordsets open. Is there a way to determine where the connection might be? TIA, Rocky ----- Original Message ----- From: "Gustav Brock" <gustav at cactus.dk> To: <accessd at databaseadvisors.com> Sent: Thursday, April 03, 2003 8:01 AM Subject: Re: [AccessD] Permission denied > Hi Rocky > > > How do I close the connections? > > By closing any database objects, recordsets and forms and controls > bound to the BE. > > I've found that the easiest and most secure way to check if this is > the case is to try to open the BE exclusively. If this succeeds you're > safe. What I do is then to compact the BE to a new file which will be > your copy. As you have opened the BE exclusively this is safe as no > other can open the BE while compacting/copying (which can take a long > time for a large database) is taking place. > > /gustav > > > >> > I get Error 70: Permission Denied when I try to execute: > >> > > >> > FileCopy gstrDatabaseName, varFileName > >> > > >> > where gstrDatabaseName contains the full valid path of the current back > >> > end and varFileName contains the full path and file name of the target. > >> > What am I doing wrong? > >> > > >> > I'm trying to give the user a way to make a backup copy of their > >> > database. Is there a better way? > > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >