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.

PAGEIOLATCH_*—Buffer latches, including the PAGEIOLATCH_EX wait type, are used to synchronize access to BUF structures and associated pages in the SQL Server database. The most frequently occurring ...

In Access 2007/2010, both tools are on the Database Tools tab in the Analyze group. In Access 2003, choose Analyze from the Tools menu. These utilities will usually catch something — in a user ...