Sometimes when I try to back up the backend files of my shared database I'm
told the file is opened when it really isn't. It's even told me that my
machine had it opened when this was not so. Any idea as to what could cause
this?

Are you sure? Have you validated with the task manager that msaccess.exe
isn't still running. Perhaps your db isn't closing properly and the process
is still active even though the application itself is no longer visible.

Is there still a lock file in the database directory?
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.



"JH" wrote:

> Sometimes when I try to back up the backend files of my shared database I'm
> told the file is opened when it really isn't. It's even told me that my
> machine had it opened when this was not so. Any idea as to what could cause
> this?

Thanks Daniel for your response. I did check the task manager when this
happened and yes Access was not showing there. However your point re db not
being closed properly makes sense because I remember on one occassion the
database would not exit and I eventually used the End Now Message box that
poped up to close it. Yes the lock file is present which makes me believe
someone else has it open but upon checking - no one did.

"Daniel Pineault" wrote:

> Are you sure? Have you validated with the task manager that msaccess.exe
> isn't still running. Perhaps your db isn't closing properly and the process
> is still active even though the application itself is no longer visible.
>
> Is there still a lock file in the database directory?
> --
> Hope this helps,
>
> Daniel Pineault
> http://www.cardaconsultants.com/
> For Access Tips and Examples: http://www.devhut.net
> Please rate this post using the vote buttons if it was helpful.
>
>
>
> "JH" wrote:
>
> > Sometimes when I try to back up the backend files of my shared database I'm
> > told the file is opened when it really isn't. It's even told me that my
> > machine had it opened when this was not so. Any idea as to what could cause
> > this?

On Wed, 22 Apr 2009 13:51:03 -0700, JH <(E-Mail Removed)>
wrote:

>Thanks Daniel for your response. I did check the task manager when this
>happened and yes Access was not showing there. However your point re db not
>being closed properly makes sense because I remember on one occassion the
>database would not exit and I eventually used the End Now Message box that
>poped up to close it. Yes the lock file is present which makes me believe
>someone else has it open but upon checking - no one did.

If you see a leftover lock file, you can try deleting it. If nobody
is using it, you'll succeed. No harm - Access will recreate it next
time. If anyone is using it, the delete will fail.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com

Thank you. I'll be sure to try that when I do may backups today!

"Armen Stein" wrote:

> On Wed, 22 Apr 2009 13:51:03 -0700, JH <(E-Mail Removed)>
> wrote:
>
> >Thanks Daniel for your response. I did check the task manager when this
> >happened and yes Access was not showing there. However your point re db not
> >being closed properly makes sense because I remember on one occassion the
> >database would not exit and I eventually used the End Now Message box that
> >poped up to close it. Yes the lock file is present which makes me believe
> >someone else has it open but upon checking - no one did.
>
> If you see a leftover lock file, you can try deleting it. If nobody
> is using it, you'll succeed. No harm - Access will recreate it next
> time. If anyone is using it, the delete will fail.
>
> Armen Stein
> Microsoft Access MVP
> www.JStreetTech.com
>
>