Hi, I have a problem with query. I have a database linked to other databases from outside. My access file is only 10 MB on the disk. I want to group my base in the last query. There are approximately 170,000 records with 20 columns. Records are displayed correctly in access.
1. While trying to group, I get the 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. '
2. On the other hand, when trying to save the database to the table, the following error appears: 'Cannot open database. It may not be a database that your application recognizes, or the file may be corrupt '(the file then takes 2 GB)
Compact and Repair Database also doesn't help in these two cases.
I need to group these records together. What can be done in this situation?