<div>
Have your bat file kill the .ldb file if it exists before compacting. &nbsp;Sometimes if a user is forced to exit Access, the .ldb locking file will remain instead of being deleted when the user exits normally. <br />
<br />
Hope this helps.<br />
-Jim
</div>


Have your bat file kill the .ldb file if it exists before compacting.  Sometimes if a user is forced to exit Access, the .ldb locking file will remain instead of being deleted when the user exits normally.

Hope this helps.
-Jim

<div>
jim's solution will work ...up to a point ...it is still possible that a user will be seen by the server as being connected even when ldb file is deleted....this is OS related as opposed to access related (which is jim's answer)<br />
<br />
I'm looking for a way to close an open file programmatically...i post back in a bit<br />

</div>


jim's solution will work ...up to a point ...it is still possible that a user will be seen by the server as being connected even when ldb file is deleted....this is OS related as opposed to access related (which is jim's answer)

I'm looking for a way to close an open file programmatically...i post back in a bit


<div>
kill the .ldb on the server where the compact is trying to take place?
</div>


kill the .ldb on the server where the compact is trying to take place?

<div>
<div class="content wysiwyg-content">
access 2000<br />
<br />
I have a scheduled compact that runs from a .bat file which sometimes works fine, other times it says &quot;You have attempted to open a database that is being used by bla bla&quot; or something like that. We have a small lan, about 10 pc's, and the error message seems to randomly think that one of them is still connected to it. I am SURE that nobody is, that Access is closed completely by a kill .bat file, etc. In other words, it seems to me that the server still THINKS that somebody is connected to it. Any ideas? Thanks.
</div>
</div>


access 2000

I have a scheduled compact that runs from a .bat file which sometimes works fine, other times it says "You have attempted to open a database that is being used by bla bla" or something like that. We have a small lan, about 10 pc's, and the error message seems to randomly think that one of them is still connected to it. I am SURE that nobody is, that Access is closed completely by a kill .bat file, etc. In other words, it seems to me that the server still THINKS that somebody is connected to it. Any ideas? Thanks.

scheduled .mdb compact thinks somebody is still using so won't run

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.