[AccessD] Permission denied

Stuart:

How do I close the connections?

Rocky

----- Original Message -----
From: "Stuart McLachlan" <stuart at lexacorp.com.pg>
To: "Rocky Smolin - Beach Access Software" <bchacc at san.rr.com>;
<accessd at databaseadvisors.com>
Sent: Wednesday, April 02, 2003 9:46 PM
Subject: Re: [AccessD] Permission denied


> On 2 Apr 2003 at 21:11, Rocky Smolin - Beach Access S wrote:
>
> > Dear List:
> >
> > 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?
> >
>
> Filecopy won't copy a file while it is open R/W by an application (which
the current database is).
> The DOS Copy command will so try doing it with a Shell() instead of using
Filecopy. But you really don't want anyone
> else in the BE while you are copying it!)
>
> The safest way is to only  do the copy when no-one else is in the BE. To
do that,  close any connections to it in the users
> front end and use the Filecopy. An Error 70 will then serve as a warning
that someone else is still using the BE and the
> backup can't be made safely.
>
>
>
>
>
>
>
>
>
>
>
>
> --
> Stuart McLachlan
> Lexacorp Ltd
> Application Development,  IT Consultancy
> http://www.lexacorp.com.pg
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>