Results 1 to 3 of 3
  1. #1
    Anetal is offline Novice
    Windows XP Access 2016
    Join Date
    Jan 2021
    Posts
    7

    Group by

    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?

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    may help - try using SELECT DISTINCT rather than GROUP BY

    Also, don't understand what this means

    On the other hand, when trying to save the database to the table,


    when you have already said

    Records are displayed correctly in access.

  3. #3
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    other thoughts

    - close down all non relevant apps and within access any form etc not required - might free up some memory
    - modify your query to try to do in smaller chunks - perhaps based on a date range

    other possibilities - your other database may have 'oversized' datatypes - long text v short text, long v integer or byte, etc. Long text in particular would be a problem for grouping anyway - only the first 255 chars

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 02-20-2019, 10:45 PM
  2. Replies: 2
    Last Post: 11-26-2016, 01:07 PM
  3. Replies: 2
    Last Post: 01-27-2016, 08:38 AM
  4. Replies: 6
    Last Post: 06-09-2015, 09:51 AM
  5. Replies: 0
    Last Post: 02-25-2013, 04:43 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums