Is anyone knows about “Query cannot be completed” error in Access 2016. I am frequently getting this error when I try to run a query having name field from 5 different tables, it gives flowing error:
"The query cannot be completed. Either the size of the query result is larger than the maximum size of a database (2 GB), or there is not enough temporary storage space on the disk to store the query result."
I don’t have any idea that how can i fix this issue. If anyone knows than please share your ideas.