Forum Discussion
Microsoft 365 Access problem
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
Michael_Darby probably you need to share the database to take a look.
- Actually I would check the free space on your drive where the database is located. Access needs space to be able to work.
