I have a module in an Access 97 database that contains the command DoCmd.TransferSpreadsheet. When this is actioned it fails with the following error message - "Can't update. Database or object is read-only. (Error 3027)".
I believe this message is a red herring because the spreadsheet trying to be created is being output to the user's C drive and the exporting folder is not read-only.
These problems have arisen after applying a MDAC pack from Microsoft. It would be helpful to know which particular DLL or OCX controls the DoCmd.TransferSpreadsheet action as I believe this is responsible for the problem.
Can anyone help please?
I believe this message is a red herring because the spreadsheet trying to be created is being output to the user's C drive and the exporting folder is not read-only.
These problems have arisen after applying a MDAC pack from Microsoft. It would be helpful to know which particular DLL or OCX controls the DoCmd.TransferSpreadsheet action as I believe this is responsible for the problem.
Can anyone help please?