Cannot update. Database or object is read-only. Error # 2950..

[Robeen]

Hi,

At new workplace, network, permissions . . .

I created a REALLY simple Macro in MS Access 2010:
SetWarnings = No,
OpenQuery = Runs a delete query to empty a table [right now 9 records],
RunCode = Runs code that reads a Text file and writes parsed data [right now 9 rows] to a table,
ImportExportSpreadsheet = exports results of a query [same 9 records] to a new spreadsheet in my Documents folder [I also tried exporting to C:\ . . .].



The Macro crashes on the ImportExportSpreadsheet step of the Macro - with the error in the subject line of this post:
Cannot update. Database or object is read-only. Error # 2950.

I've done this a hundred times at other sites - so I'm guessing this is permissions-related? . . . but I don't know what is causing the problem.

I am able to create, modify, delete a spreadsheet to either of the locations [My Documents, C:\] - but I just cant do it from the Macro.

I'd appreciate any help!

Thanks!!

[Robeen]

Just as a test, I created a separate Macro with only a RunCode Action.
The Action runs code that copies a file [I tried with a .txt file and a .xlsx file] from my documents and writes the copy [with "Copy" added to the file name] to the same folder. No problem there - the copy works just fine. So Access IS able to write to that folder.
. . . not sure how - but that might help towards a solution?

Thanks again!!

[Robeen]

I just tried one more thing:
I right-clicked the query name [in the Navigation Pane].
Selected Export -> Excel
Provided the path & File Format etc & clicked OK . . .
And it worked. no problem executing the export manually in this way.

[Robeen]

I found a way around it:
I put a "DoCmd.TransferSpreadsheet acExport. . ." in the code I was already running prior to the macro action ImportExportSpreadsheet - and the export works fine.

No idea why the Macro Action will not work for me!

Thanks!