[AccessD] Permission denied

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
>




More information about the AccessD mailing list