There is no shortage of opinion over Microsoft's efforts to point database developers away from its year-old LINQ to SQL data access method to its more recently released ADO.NET Entity Framework.
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 ...