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.