I have an access front-end to a SQL server database.
To create a new record the front-end runs an INSERT statement in VBA. But this statement hangs if another user is editing the table.
I think I need to know more about how record locks work. Where can I get more information?