<div>
Perfect, thanks for the help, Jim.<br />
<br />
Dave
</div>


<div>
Dave,<br />
<br />
&nbsp;I should have added another piece that you might want to implement as part of this:<br />
<br />
How to detect User Idle Time or Inactivity in Access 2000<br />
<a href="http://support.microsoft.com/kb/210297" rel="ugc nofollow">http://support.microsoft.com/kb/210297</a><br />
<br />
&nbsp;This show you how to kick out users based on inactivity. &nbsp;This in conjuction with a lock out flag gives you a good all a round solution.<br />
<br />
&nbsp;I also should have mentioned that the reason you don't want to force a user out of Access externally is that it can cause database corruption.<br />
<br />
Jim.
</div>


Dave,

 I should have added another piece that you might want to implement as part of this:

How to detect User Idle Time or Inactivity in Access 2000
http://support.microsoft.com/kb/210297 [http://support.microsoft.com/kb/210297]

 This show you how to kick out users based on inactivity.  This in conjuction with a lock out flag gives you a good all a round solution.

 I also should have mentioned that the reason you don't want to force a user out of Access externally is that it can cause database corruption.

Jim.

<div>
The very issues I was addressing in my mind while contemplating the next move. &nbsp; Thanks very much for the thoughtful follow-up.
</div>


The very issues I was addressing in my mind while contemplating the next move.   Thanks very much for the thoughtful follow-up.

<div>
<div class="content wysiwyg-content">
I need to make updates from time to time in Access. &nbsp; If another user has the company db open, I can't export modules to it. &nbsp;Can I close the db from my workstation? &nbsp;If so, how?
</div>
</div>


I need to make updates from time to time in Access.   If another user has the company db open, I can't export modules to it.  Can I close the db from my workstation?  If so, how?

Access 2007 Can I close Access on another user's computer in VBA?

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.

Microsoft Access

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.