Microsoft 365 Access problem

Occasional Visitor

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 

2 Replies

@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.