Find the Current Status of a Table / Recordset

[ian_w]

Im trying to check on the current status of a table / recordset in Access 97.

I've currently got it so the following happens;

User 1 runs the procedure and table and recordset are opened.

If at the same time User 2 attempts to run the procedure then it errors with code 3262 and I capture it.

What I would like it if User 2 attempts to run the procedure then I can check the status of the recordset and if its currently locked by a user prompt them and have the procedure by passed rather than running into an error handler.

Currently using DAO but im happy to try ADO

 

[nIGHTmAYOR]

What I would like it if User 2 attempts to run the procedure then I can check the status of the recordset and if its currently locked by a user prompt them and have the procedure by passed rather than running into an error handler.

interesting , why isnt "On error resume next" doing it for u since u r about to use coding anyway?