Using DoCmd.OutputTo from a remote database

[ByronC via AccessMonster.com]

I'm new to sql, so please pardon my ignorance. I am attempting to convert
existing code (shown below) to run in a remote database. How do I tell
Access to run the query "WedgeTbl_Crosstab" in the remote database and output
to Excel? The remote database is a temporary database created on the user's
desktop and the below query is copied in using DoCmd.TransferDatabase.

Existing code:
DoCmd.OutputTo acOutputQuery, "WedgeTbl_Crosstab", acFormatXLS, strFilePath &
strFileName, True

The location of the remote database is located here:
"C:\Documents and Settings\" & CurrentUser & "\desktop\WedgeTemp.mdb"

Thanks....

 

[NuBie via AccessMonster.com]

I'm not sure if you can run a query from another database remotely, (or at
least i haven't done this) a work around would be linking the table, copy the
query into your DB then Docmd.OutputTo ....

Maybe someone has a better idea on this matter.

 

[ByronC via AccessMonster.com]

Thanks for the reply. That's the direction we decided to take.

I'm not sure if you can run a query from another database remotely, (or at
least i haven't done this) a work around would be linking the table, copy the
query into your DB then Docmd.OutputTo ....

Maybe someone has a better idea on this matter.

I'm new to sql, so please pardon my ignorance. I am attempting to convert
existing code (shown below) to run in a remote database. How do I tell

[quoted text clipped - 10 lines]

Thanks....