Hello.
Is it possible to know with ODBCDBE if one table is open and close it.
I mean if it was opened before a new conecction and by other user o machine, 
not from my computer by me.
Regards.
César.

Yes it is (as I know for MSSQL and MySql/MariaDB). What you should be looking
is 'list of open cursors' at database. 

http://stackoverflow.com/questions/265605/is-there-any-way-to-get-a-list-of-open-allocated-cursors-in-sql-server

https://gallery.technet.microsoft.com/scriptcenter/List-all-open-Cursors-7ebec7f6

So via stored procedures and executing calls can probably be done. It is used
to pin down some run-away procedures and/or problematic users/tools that
access db from outside (analytical tools).

But on the other side, you cannot close other connections via ODBC if someone
other has open cursor to that table on server. Actually, it is not in sense
how SQL works (locking) from client side and holding resources.

For local odbc connections to xlsx, dbf, .sqllite I have actually no idea.



César Calvo <ccalvoc@telefonica.net> wrote in message
news:72f22b1$33396c99$1f1b5@news.alaska-software.com...
>Hello.
>Is it possible to know with ODBCDBE if one table is open and close it.
>I mean if it was opened before a new conecction and by other user o machine, 
>not from my computer by me.
>Regards.
>César.