Hi Peter,
Tom sent me your database and I tested it too -- ran fine in about 20
minutes with the points and number of graphs specified. Then I
increased the points to 100 and the number of graphs to 1000 -- took
about 3-1/2 hours, but it never failed
It is hard to suggest a solution for a problem that doesn't happen for
me, but I will look at the code and see if I see anything that you might
want to change...
Warm Regards,
Crystal
*
(: have an awesome day
*
MVP Access
Remote programming and Training
strive4peace2006 at yahoo.com
*
Tom Wickerath wrote:
Hi Peter,
I have tested the sample database that you sent to me, using two different
PC's. In both cases, all 1000 snapshot files were created without any
problem. At this time, I am unable to reproduce the failures that you are
experiencing.
Tom Wickerath
Microsoft Access MVP
http://www.access.qbuilt.com/html/ex...tributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________
"Tom Wickerath" wrote:
Hi Peter,
Are you going to be able to send any type of a cut down sample DB to me,
which replicates the problem on your PC?
Tom Wickerath
Microsoft Access MVP
http://www.access.qbuilt.com/html/ex...tributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________
"Peter B" wrote:
Update - I added some VBA code to my test database to export the
snapshots one file at a time. This is also part of my automated
process that is bombing on me. This also gets away from any TEMP space
issues associates with huge snapshot exports.
I started the export process before I left work yesterday. If
successful, I would have 1000 snapshot files parked on my c: drive in
the morning. Well, got here this morning, and after only 34 exports, I
have the same Access unhandled exception on my screen. I shut down,
relaunched Access and tried to export again, and after 70 exports,
Access bombed out on me.
I am going to try to repeat this a few times, and if I can, I can then
make changes to see what fixes it.