<div>
What do you mean by open? &nbsp;A edit, append, delete on a particular record?
</div>


What do you mean by open?  A edit, append, delete on a particular record?

<div>
I have opened a table with DoCmd.Open.<br />
I'd like to know if it the user has closed it, and if not, ask them to do so or warn them that I am about to do so. <br />
<br />
Basically, I can't do anything to that recordset since the table is being used by the user right. <br />

</div>


I have opened a table with DoCmd.Open.
I'd like to know if it the user has closed it, and if not, ask them to do so or warn them that I am about to do so.

Basically, I can't do anything to that recordset since the table is being used by the user right.


<div>
You'll want to check 'syscmd' function to determine the state of the table object.
</div>


You'll want to check 'syscmd' function to determine the state of the table object.

<div>
Awesome! Thanks Staszko. It worked well for me. I was unaware of the CurrentData object.
</div>


Awesome! Thanks Staszko. It worked well for me. I was unaware of the CurrentData object.

<div>
<div class="content wysiwyg-content">
How can I check if a table is open in Access?
</div>
</div>


How can I check if a table is open in Access?

How to check if table is open?

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.