is an access table open??

hi,

i have a program that uses an access database. it could be that 2 users are in the database.
Is there a way to check if a table is in use (so table, not database) by another user??

thanx

This is possible (in a round-about way). If you use the appropriate locking options on the table (when you call recordset.open) an error will be thrown informing that the table is already in use.
HTH