compact and repair

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Good day All.
I have a server-initiated (cmd) VBA batch job that compacts and repairs the
Back-End. Periodically a user shuts down before logging off the Access app,
and locks up the process. How can I clear road-blocks (Permission denied
(Error 70))
and manually run this process. Do I have to do this via the O/S and, if so,
where in Windows do I clear shares?
thanks in advance.
 
Hi.
Periodically a user shuts down before logging off the Access app
Click to expand...

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

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

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.
 
Hi Camaro
The procedure is:

1. Access ‘Control panel/Administrative tools/Computer Management/Shared
Folders/Open Files’
2. Close relevant open files (right button)
Hi Camaro
 
Back
Top