J
Jeff Schneider
I have a Access 2002 database exporting about 10 queries to HTML files. This
has been working smoothly for years, until yesterday...
Suddenly, they take much longer to run, and sometimes I receive the error:
make sure you have enough free disk space on your destination drive." But
I've got 9 GB of space on the server, and each file is only 1-2 MB. Lastly, I
don't get the error on the same query every time - it changes each time.
I've done compact & repair, and even pulled an archived copy of the DB from
several months ago and ran it with old data - same problem.
Any suggestions on what might have happened? or what else i can look for?
Here's my code (repeating ten with a different query name each time):
DoCmd.OutputTo acOutputQuery, "qryMOH_Crosstab", acFormatHTML,
"\\server003\daily\MOH_Reports\Daily1.html", False, ""
has been working smoothly for years, until yesterday...
Suddenly, they take much longer to run, and sometimes I receive the error:
make sure you have enough free disk space on your destination drive." But
I've got 9 GB of space on the server, and each file is only 1-2 MB. Lastly, I
don't get the error on the same query every time - it changes each time.
I've done compact & repair, and even pulled an archived copy of the DB from
several months ago and ran it with old data - same problem.
Any suggestions on what might have happened? or what else i can look for?
Here's my code (repeating ten with a different query name each time):
DoCmd.OutputTo acOutputQuery, "qryMOH_Crosstab", acFormatHTML,
"\\server003\daily\MOH_Reports\Daily1.html", False, ""