By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,586 Members | 623 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,586 IT Pros & Developers. It's quick & easy.

DoCmd.OutputTo acQuery, using XLS format just hangs

P: n/a
Newbie here, so please bear with me.

I have a module that just hangs. I have tracked it down to this line in
the genMappings() module:

DoCmd.OutputTo acQuery, "Mappings", acFormatXLS, _
"s:\_DataModel\LatestDelivery\Mappings_Rev0_Draft. xls", True, ""

When this line is executed, the Access application hangs. It does
generate the .xls file, but it does not close the file. It acts like it
is waiting on more data. The Task Manager shows the Access application
as "not responding", and the memory and cpu levels are nearly zero used
(i.e. not running out of cpu or memory). Once I kill the application,
the .xls file is invalid.

Here is what I have tried:

1. Execute the "Mappings" query manually - it works fine.

2. Execute the "Mappings" query manually, then manually export to .xls
- it works fine and I get a valid .xls file.

3. Check permissions/space on the output directory - everything is
fine.

4. Changed the format from acFormatXLS to acFormatRTF - a valid RTF
file is created and opened, but the module bombs out later.

5. Toggled the "start" parameter from True to False - this had no
affect, since the .xls file is never completely closed.

Have you seen this problem before? Any suggestions?
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.