I know that a variety of questions have been asked for Error 3048: Cannot open any more databases, but I do not think that they fully deal with the problem that I am having. I would also like to add that I am very new to programming.
I am using MS Access 20003 to create a query. This union query that has 13 SELECT statements, and once the query is ran I receive the error message saying that no more databases can be open. Is there any way around this? I am selecting all of this information for one summary report within the program.