Increase maximum database size to 4GB and increase maximum Query size past the current 1GB limit
I have a 78 million record 2 field table that indexes both fields fine. When that table is 82 million records, neither field will index because of a query limit error. The 1 GB query limit must be interfering with the indexing of a table that would otherwise not violate the 2 GB limit?? Also, increase the size of the access database container to 4GB....not asking for SQL Server replacement, just something we can work with. MS upsized and oversized Excel years ago.