Thank you guys for your help.

@sqlknowitall - Jared: The access is connected to the SQL server via an ODBC connection.

@DiverKas: All tables are indexed. I don't...