Rocky Smolin - Beach Access Software
bchacc at san.rr.com
Thu Apr 3 10:49:55 CST 2003
Nope. ----- Original Message ----- From: "Marcus, Scott (GEAE, RHI Consulting)" <scott.marcus at ae.ge.com> To: <accessd at databaseadvisors.com> Sent: Thursday, April 03, 2003 8:24 AM Subject: RE: [AccessD] Permission denied > Rocky, > > You don't have a global recordset variable do you? Just checking.... > > Scott > > -----Original Message----- > From: Rocky Smolin - Beach Access Software [mailto:bchacc at san.rr.com] > Sent: Thursday, April 03, 2003 11:11 AM > To: accessd at databaseadvisors.com > Subject: Re: [AccessD] Permission denied > > > 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 > > > > > _______________________________________________ > 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 >