Which PC has table open?

[Les Isaacs]

Hi All
I have a split FE/BE 2010 accdb, and sometimes I am prevented from making a table design change because the table is open on someone's PC. Is there a way to find out the ID of the PC where the table is open? This would save me quite a bit of legwork!
Thanks for any help.
Les

 

[DJkarl]

Don't think there's anyway to pinpoint which table someone has open, but if you look at the .laccdb file the PC's currently connected will be listed in there.

 

[spikepl]

http://lmgtfy.com/?q=who+is+logged+in+access

But as to specific table then DJkarl' is right, I think.

 

[gemma-the-husky]

it can't happen very often, though, surely. you don't redesign tables very often.

 

[Les Isaacs]

Hi All
Many thanks for your replies: I certainly learnt something (always wondered what the laccdb was for - never tried opening it!), and have sorted my problem (by creating a simple 'loggedIn' table and populating/deleting from this as the swichboard form opens/closes - as per one of the ideas from spikepl's link).
Thanks again
Les