Can't update. Database or object is read only

[Reiner Harmgardt]

Hi NG

if i do the following command:

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel97, xExcelTarget,
xPathExcelWB & xExcelWB & ".XLS", True

i receive the following error:

runtime-error 3027:

Can't update. Database or object is read only.


This is a functionality which is used for a longer time and is working fine
for some users
for others. even not for me right also i'm having more rights than the
normal user.
The directory where the transfer should go to is not write protected.

We are working with ACCESS97 (SR-2) and Excel 2000 (SP-3)
ACCESS2000 is also installed on my machine.


No idea what could be the problem, cause for some users it works
and for some not.

Thanks for helping

Regards

Reiner

 

[Reiner Harmgardt]

Hi NG

Found the solution on my own.

The problem was, that the length of xPathExcelWB & xExcelWB & ".XLS"
exceeded 64.
if it's 64 or less it's ok.
if it's above then this error-message occurs.

Regards to you all

Reiner