Microsoft 365 Access problem

%3CLINGO-SUB%20id%3D%22lingo-sub-876195%22%20slang%3D%22en-US%22%3EMicrosoft%20365%20Access%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-876195%22%20slang%3D%22en-US%22%3E%3CP%3EI%20save%20the%20Access%20file%20I%20was%20working%20on%2C%20did%20Compact%20and%20Repair%20then%20saved%20to%20backup%20(on%20a%20USB).%3C%2FP%3E%3CP%3EThe%20file%20has%20only%20around%20400%20records%20with%20maybe%2080%20fields%20and%20maximum%202Kb%20data%20plus%20one%20low-res%20photo%20per%20record.%3C%2FP%3E%3CP%3E%26nbsp%3BI%20then%20attempted%20to%20reopen%20the%20file%20and%20received%20this%20message%3A%3C%2FP%3E%3CP%3EThe%20query%20cannot%20be%20completed.%20Either%20the%20size%20of%20the%20query%20result%20is%20larger%20than%20the%20maximum%20size%20of%20a%20database%20(2GB)%20or%20there%20is%20not%20enough%20temporary%20storage%20space%20on%20the%20disk%20to%20store%20the%20query%20result.%3C%2FP%3E%3CP%3EThe%20same%20message%20came%20when%20I%20tried%20to%20load%20the%20backup%2C%3C%2FP%3E%3CP%3EWhat%20I%20have%20done%20differently%20from%20usual%20is%20that%20I%20needed%20the%20input%20form%20to%20be%20in%20alphabetical%20order%20so%20linked%20the%20form%20to%20an%20alphabetical%20query%20using%20Property%20Sheet%20%2F%20data%2F%20Record%20Source.%3C%2FP%3E%3CP%3ESome%20kind%20person%20please%20help%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-876195%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3E365%20Access%20Problem%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-876452%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20365%20Access%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-876452%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F415464%22%20target%3D%22_blank%22%3E%40Michael_Darby%3C%2FA%3E%26nbsp%3Bprobably%20you%20need%20to%20share%20the%20database%20to%20take%20a%20look.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-878415%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20365%20Access%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-878415%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F415464%22%20target%3D%22_blank%22%3E%40Michael_Darby%3C%2FA%3E%26nbsp%3Bit's%20really%20a%20hard%20problem.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-888830%22%20slang%3D%22en-US%22%3ERE%3A%20Microsoft%20365%20Access%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-888830%22%20slang%3D%22en-US%22%3EActually%20I%20would%20check%20the%20free%20space%20on%20your%20drive%20where%20the%20database%20is%20located.%20Access%20needs%20space%20to%20be%20able%20to%20work.%3C%2FLINGO-BODY%3E
Highlighted
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
Highlighted

@Michael_Darby probably you need to share the database to take a look.

Highlighted
Actually I would check the free space on your drive where the database is located. Access needs space to be able to work.