Sep 25 2019 10:46 PM
I save the Access file I was working on, did Compact and Repair then saved to backup (on a USB).
The file has only around 400 records with maybe 80 fields and maximum 2Kb data plus one low-res photo per record.
I then attempted to reopen the file and received this message:
The query cannot be completed. Either the size of the query result is larger than the maximum size of a database (2GB) or there is not enough temporary storage space on the disk to store the query result.
The same message came when I tried to load the backup,
What I have done differently from usual is that I needed the input form to be in alphabetical order so linked the form to an alphabetical query using Property Sheet / data/ Record Source.
Some kind person please help
Sep 26 2019 01:12 AM
@Michael_Darby probably you need to share the database to take a look.
Oct 02 2019 06:58 AM