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.
Mark Burns commented
I'm unsure of the 1GB limit in terms of technical architecture issues, but the 2Gb limit is insurmountable given the present architecture of .mdb/.accdb files because back when the JET engine was first created (1980s!), nothing in PC architecture was BIGGER than the 32-bit address space, which tops out at 2GB. 32-bit addresses were used internally in architecting the .mdb (and .accdb) file formats, so it will require a complete re-tooling of the database engine to support anything bigger than a 2GB database file (as well as a new file format, internally).
I'm not saying I wouldn't support it - I fervently do! - I'm just explaining the depth of the issue and why it's just "not so easy".