Access 2010 - transferspreadsheet generates (sometimes) error 3027

[chief68]

Hello

I prepared an access tool and i distributed to the users
In this tool there is a table and I export it in an external excel file with this command

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12, "Export", app

Now, this is a normal command, no objects involved, strange libraries or other
Well, on my PC it works, on the PC of several users it works, on the PC of someone it DOESN'T work and gives this message

Run time error 3027:
Cannot update. Database or object is read-only

This error has no sense for that command

I made a check on one of this PC
No MISSING libraries in the references

There is just a little difference because I use libraries 14.0, while in the PC where the error occurs there are 16.0 but i don't think this is the real problem

Any idea?
Thanks in advance

A

[ranman256]

is it possible you do not have rights to that folder you are sending it to?
and if the user has the file open, it will error then too.

[ssanfu]

In the past, I had problems with transferspreadsheet also. Then I found this site: https://ss64.com/access/acspreadsheettype.html

Notice that "acSpreadsheetTypeExcel12" is for Access 2007 and
"acSpreadsheetTypeExcel12xml" is for Access 2010 (and probably later versions)

[chief68]

is it possible you do not have rights to that folder you are sending it to?
and if the user has the file open, it will error then too.

Hi ranman, thanks for your answer

It's one of the attempts i did
The user has "full control" on the destination folder

A

[chief68]

In the past, I had problems with transferspreadsheet also. Then I found this site: https://ss64.com/access/acspreadsheettype.html

Notice that "acSpreadsheetTypeExcel12" is for Access 2007 and
"acSpreadsheetTypeExcel12xml" is for Access 2010 (and probably later versions)

Thanks ssanfu for your answer

I will try, but in any case, this just set the format of the destination excel file and i don't think that only a particolar file format has the chance to be saved
And why only on particular PC?