In Access 2021 on Windows 10, I have linked a 1.9GB text file (28 million records, 3 fields). I need only a subset of those records. Unfortunately, attempts to query the table to produce that subset result in an error:
The query cannot be completed. Either the size of the query result is larger than the maximum size of a database (2 GB), or there is not enough temporary storage space on the disk to store the query result.
There may be other solutions. I welcome suggestions of that nature. But here is my actual question:
Access sees two of that table's three fields as 255-character Short Text. In fact, I need only 75 characters to accommodate the entries in one of those two fields, and 36 characters for the other.
I don't know whether truncating those fields to those lengths in an output table or query would save enough space to avoid the error message. But is there a way to try?
The query cannot be completed. Either the size of the query result is larger than the maximum size of a database (2 GB), or there is not enough temporary storage space on the disk to store the query result.
There may be other solutions. I welcome suggestions of that nature. But here is my actual question:
Access sees two of that table's three fields as 255-character Short Text. In fact, I need only 75 characters to accommodate the entries in one of those two fields, and 36 characters for the other.
I don't know whether truncating those fields to those lengths in an output table or query would save enough space to avoid the error message. But is there a way to try?
![[wiggle]](/data/assets/smilies/wiggle.gif "[wiggle] [wiggle]")
