"'69 Camaro" wrote:

> 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.
>
>
>