Create front ends for the Access DB. It will allow locking per-record instead of the entire db. I've heard that migration to SQL Server isn't that difficult either. I don't see why it would ever be a ...

Lock contention issues can be frustrating problems to investigate and debug. But anytime a database system is involved, the potential exists for locking to cause concurrency problems. Before blaming ...