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 when I run the query it is still trying to pull all data from the table.
I have done searches on using criteria for queries and am fairly confident that I have done it correctly. In the date field I have tried both " Between #date# and #date# " and also Between [Start Date] and [End Date]. Neither limited the data that the query pulled.
I am going a bit crazy here and any assistance would be greatly appreciated.