I am using Microsoft Access 2010 and attempting to use a query to pull select data from a linked database. The link is via ODBC.

My connection with the database is fine, I have successfully pulled data from smaller tables. The table I am querying contains approx 50k records. When I write a query to pull all records, Access crashes.

I have attempted to use criteria to pull smaller chunks of data (i.e. by date) but...