Transactions, Locking, and Concurrency in Access and SQL Server
This topic explains how transactions are executed in both Microsoft® Access and Microsoft SQL Server™ and discusses the difference between the locking process and concurrency issues in both database types.