Database "Not Responding" during Table export to Excel

[Guest]

This doesn't happen all the time. But, it happens enough to be annoying. I
have to export two tables from a shared Access 2003 Database (Access 2000
format) to Excel. I have a macro created using the OutputTo function that
places the spreadsheets in a folder on a local file server. Usually
everything goes OK. Sometimes during the export process my Access database
stops responding. I have checked to make sure all the database users
workstations are updated and running the current Jet Version. Finally, I
will only export the tables when I know no one else but me is in the
database. The only solution that seem to fix this is to have our network
group reboot the server this database is located on. What else should I be
looking for to keep this from happening. Thanks!

 

[Roger Carlson]

When Access is "Not Responding" it doesn't mean it's stopped working. It
means the process you are running in it is not responding *to the Access
UI*. The process is (usually) still running. You can see this by going to
your Windows Task Manger and switch to the Processes tab. If the number in
the CPU column for the Access process is changing, then your export is still
working. Just be patient and it will finish eventually. If it's not, you
can click the End Process button to kill it. You should only do this as a
last resort, however, because this can corrupt your database under certain
conditions (mostly if the database is updating records at the time).

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Guest]

Thanks Roger. The next time I run the export. I will look for this.

Bill Beshlian