This can be fixed by changing the 'QueryTimeout' Property in the registry.
Settings and Return Values: The setting or return value is an Integer representing the number of seconds to wait. The default value is 60. Set to 0 if you want to wait indefinitely.
More information on the 'QueryTimeout' Property: When you're using an ODBC database, such as Microsoft SQL Server, there may be delays due to network traffic or heavy use of the ODBC server. Rather than waiting indefinitely, Access allows you can specify how long to wait. When you use QueryTimeout with a Connection or Database object, it specifies a global value for all queries associated with the database. You can override this value for a specific query by setting the ODBCTimeout property of the particular QueryDef object.
Set it to 0 if you had a table with more than 100,000 records.
In a Microsoft Jet workspace, you can override the default value by creating a new “ODBC” key in the Registry path \HKEY_LOCAL_MACHINE\SOFTWARE\MICROSOFT\Jet\4.0\ENGINES\ODBC, creating a QueryTimeout parameter in this key, and setting the value as desired.