[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