Hi
I have been tasked with some old access databases that need updating. These databases produce reports that are then exported to our onsite server. We are now in the process of moving to SharePoint, can we still export to the query to SharePoint?
We currently use DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12, "Summary Report Period End", "\\localserver" & Format(Date, "yyyymmdd") & " Summary & Movement Report" & ".xlsb", True, "data"
I tried to change the location of the save file to the SharePoint server and get a runtime error '2825': The file does not exist, or you don't have read access to the file. Have tried to speaking to our sharepoint people but they are not interested!
Any help would be appreciated, thanks.