Hi.
Periodically a user shuts down before logging off the Access app
That's a recipe for corrupted databases. Train the users never to do this.
How can I clear road-blocks (Permission denied
(Error 70))
and manually run this process.
To clear the network file lock, you need a network administrator's security
permissions to unlock it. Network administrators normally use a Windows GUI
to remove the file locks, but you could probably program the process and
call it from a batch file if you needed to, provided you have a network
administrator's security permissions and the programming skills.
Otherwise, reboot the computer system where the database file is located to
clear the file lock. That's probably not practical on a networked server,
though.
Do I have to do this via the O/S and, if so,
where in Windows do I clear shares?
You have to do it from the OS on a domain controller on the network, which
requires a network administrator's security permissions to connect to it or
log onto it. I suspect you don't have these permissions, due to the
questions you're asking which are very basic for a Windows network
administrator. (Which is understandable if you're new to the job as network
administratior and haven't had any training yet.)
HTH.
Gunny
See
http://www.QBuilt.com for all your database needs.
See
http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs:
www.DataDevilDog.BlogSpot.com,
www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.