[AccessD] Clear Locks Via OS (was: A table that can't beduplicated)

Hi Gustav,
Thanks for the tip I'll give it a try when I get it downloaded (I'm having
connection problems this week and the download keeps getting cut off on me!)

John

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Gustav Brock
Sent: Wednesday, August 18, 2004 12:43 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Clear Locks Via OS (was: A table that can't
beduplicated)

Hi John

If a process is open (running) keeping the file locked, you may use
PsKill to terminate that process:

  http://www.sysinternals.com/ntw2k/freeware/pstools.shtml

/gustav


> This is what I am trying to do from the workstation. (I recently asked
about
> this on DBA-Tech).

> I have a customer site where their 3rd party app is constantly leaving an
> mdb & ldb file open on the server every time they use the apps. (I can't
> touch the apps - VB using A97 mdb BE). I am looking for a way to do this
> from the workstation because as simple as it sounds, the client is afraid
of
> logging onto the server to do this and the developer is non-responsive to
> the problem. (Your message below is what I have them doing now plus
closing
> the hung mdb & ldb files for the user that is no longer using the app.)

> Any idea of whether I can do this from the workstation? Maybe wrap the
apps
> startup in a batch file that calls the app and when done calls a script to
> clean it up?

--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com