Hi, I use ASP & MS Access. I want to implement a "Block on Select" scenario, which means only one user at a time can read some data from a table or a recordset. Other users have to wait until the first user is done.

Can I do it like this:

Application.lock
DB operations here
Application.unlock

Will this guarantee the exclusive reading of the recordset?

Thanks
jming