MS Access can't complete the output operations

[Hursan]

I have an MS Access database with an export button to export data from a report to excel, was working fine but out of no where i started to get an error message, first was my PC only but not is spreading to other PCs. we all have the same front end database version. not sure how to fix this. any help is appreciated.



Enable GingerCannot connect to Ginger Check your internet connection
or reload the browserDisable in this text fieldRephraseRephrase current sentenceEdit in Ginger×

[ranman256]

where does it export? Try using your local PC ,c:\temp\ to see if this solves it.

try TransferSpreadsheet,
make a custom function to see if this works

function ExportXL()
docmd.TransferSpreadsheet acExport ,acSpreadsheetTypeExcel3 ,"qsMyQuery","c:\temp\MyFile.xls",true
end function

then you can run it in the macro : RUNCODE ExportXL()

[CJ_London]

I don't use macro's but shouldn't Output File be populated with a path and file name? Perhaps specified in Arguments, but still don't see a path

Also what is this about?

Enable GingerCannot connect to Ginger Check your internet connection
or reload the browserDisable in this text fieldRephraseRephrase current sentenceEdit in Ginger