J
Jon Webb
I'm getting error 3219 in this code:
DoCmd.OpenReport "rptCount_summary_by_insurer", acViewPreview
The report referred to has a nested query defined in it. The second-level
query refers to linked tables in an external SQL database. I suspect this
nesting and/or the use of linked tables is what is causing the 3219 error.
The thing is, I see this error only with some SQL databases. Could Access be
running out of memory space when it tries to run the nested query? Would that
result in error 3219?
As a workaround I moved the second-level query into a view in the SQL
database. That seems to have fixed, or at least hidden, the problem. But I'm
not confident it won't pop up again in a different context.
Can anyone give me any insight into why this error might happen only
occasionally?
DoCmd.OpenReport "rptCount_summary_by_insurer", acViewPreview
The report referred to has a nested query defined in it. The second-level
query refers to linked tables in an external SQL database. I suspect this
nesting and/or the use of linked tables is what is causing the 3219 error.
The thing is, I see this error only with some SQL databases. Could Access be
running out of memory space when it tries to run the nested query? Would that
result in error 3219?
As a workaround I moved the second-level query into a view in the SQL
database. That seems to have fixed, or at least hidden, the problem. But I'm
not confident it won't pop up again in a different context.
Can anyone give me any insight into why this error might happen only
occasionally?