Hi,

I'm working with an Ms-Access 2000 project (ADP) with a SQL
server back-end. I am attempting to create an Excel backup file of
report information.

I have a procedure that runs when the report closes. It
creates a view of the report information, outputs the view to Excel in
a specified network location, and then deletes the view. My line of
code for outputting the view is as follows:

DoCmd.OutputTo acOutputServerView, strQueryName, acFormatXLS,
strSpeadsheetName, False

There are about 200 users and only 8 are having a problem. For
these 8, the Access application just "blows out" when it hits the
"DoCmd.OutputTo ..." line above. Although I have error handling in the
procedure to produce an error message and close down the report
properly, I get no error message generated. The report closes, but so
does the whole application.

It is not a network or rights issue; it is specific to the 8
machines of the users having the problem. It is not specific to Excel,
as I can change the output format in the statement above to
"acFormatTXT" instead of "acFormatXLS", and the 8 users still have the
same problem. And did I mention that there is nothing "obvious" which
links the 8 users having problems? :-)

All users are running the same version of runtime Ms-Access
2000 and all are supposedly running the same version of Ms-Office 2000
for Excel and Word.

I'm not sure how to proceed next because I'm not getting any
kind of error message. Any suggestions would be greatfully received.

Thanks,

Karen