Home

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
Michael_Darby
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.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies