When you split an Access database file, you end up with two .mdb files instead of just one: ... However, a modified Access front end that’s linked to SQL Server, can also buy you time.

You can also use distributed transactions whenever there's SQL Server to SQL Server communication and changes will be made to data during the course of the transaction, often done via a linked server.