Forum Discussion
Error 3048 when exporting
Hello, I am attempting to export a database to an excel file. Access creates an empty file, and throws the error "Cannot open any more databases", which from what i've seen so far, is error 3048...
Should this really be "UNION", or "UNION ALL"?
You are very likely running into the max complexity for an Access query.,
As others have said: a discussion of your database design may be in order. Be open to that, please.
If you don't want to go there: turn the first query into MakeTable, and the others into Append queries, then export the table. A horrible solution in my book, but it would get the job done without errors.
You are very likely running into the max complexity for an Access query.,
As others have said: a discussion of your database design may be in order. Be open to that, please.
If you don't want to go there: turn the first query into MakeTable, and the others into Append queries, then export the table. A horrible solution in my book, but it would get the job done without errors.
Hi. Nothing much to add to the above suggestions but glad you found my available connections add-in useful, if only to eliminate one possible reason for your current issue.
You may also wish to investigate increasing the MaxLocksPerFile and MaxBufferSize settings.
