Access 2000 freezes after doing Docmd.transferspreadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm running simple code behind a form button. I issue four separate
Docmd.transferspreadsheet commands that export a queries to excel
spreadsheets. The transfers occur, but then Access freezes up and I have to
quit and come back in. Does anyone have any idea why Access would freeze up?
 
I've never heard of transferspreadsheet causing that kind of thing so don't
really have much of a suggestion.... but might be worth seeing if you can
isolate which spreadsheet is causing the problem. Is it always the same
one? If you have four buttons that each do one export then do you get the
same issue?


Marjie said:
I'm running simple code behind a form button. I issue four separate
Docmd.transferspreadsheet commands that export a queries to excel
spreadsheets. The transfers occur, but then Access freezes up and I have to
quit and come back in. Does anyone have any idea why Access would freeze
Click to expand...
up?
 
I discovered what my problem was. It was not the transferspreadsheet, as you
suspected, but poor coding of the application.echo command. I fixed that and
its running fine now. Thanks
 
Back
Top