backup shared database issues

  • Thread starter Thread starter JH
  • Start date Start date
J

JH

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.
 
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.
 
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.
Click to expand...

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
 
Back
Top