I have VBA code that allows me to run Access Queries from within Excel. It works fine except when running large queries.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
The Access query works when I run it when I am in Access. It does not work when I try to run it (using the VBA code) from Excel. There are no error messages. Other Access queries work...just this one does not. The basic difference between this query and the others, is this query has several (500k) records.
<o></o>
<o></o>
I have set CommandTimeout = 0. Is there something else I can do to allow large queries to work?
<o></o>
<o></o>
Thank you in advance for your help.<o></o>
Jack
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
The Access query works when I run it when I am in Access. It does not work when I try to run it (using the VBA code) from Excel. There are no error messages. Other Access queries work...just this one does not. The basic difference between this query and the others, is this query has several (500k) records.
<o></o>
<o></o>
I have set CommandTimeout = 0. Is there something else I can do to allow large queries to work?
<o></o>
<o></o>
Thank you in advance for your help.<o></o>
Jack