Error 3027

[Guest]

I am using the method:

docmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel97,
"MySpecification", strPath & "\MyFile"

when the strPath is "c:\" I mind the root, it works, but
when the strPath is "c:\Documents and settings\myuser\my documents\" it says
"it can't update ERROR 3027, the database o the object is readonly"

Somebody can help me?

 

[John Nurick]

Hi Raul,

Could this be a permissions issue? Does the user account under which
Access is running have sufficient access to the "myuser" folder?

 

[Guest]

Hi John,

The user account which access was installed was the PC Administrator on Win
XP, and the user running the application .mdb is domain user account that
have a perfil on the PC, also belongs to the Administrators PC group , I
really don't know where I have to check, do you?

I really apreciate.

 

[John Nurick]

If the user can create, modify and delete files in the folder
permissions aren't the problem.

One common cause of error 3027 is non-standard file extensions, though
this is more often encountered using TransferText than
TransferSpreadsheet. Looking closely at your code it seems that you're
not using the .xls file extension. Try using it.

Looking more closely, I notice that you are using
strPath & "\MyFile"
for the filespec, but
"c:\Documents and settings\myuser\my documents\"
for strPath. That would give you

c:\Documents and settings\myuser\my documents\\MyFile

which will fail thanks to the doubled backslash.

Error 3027 can be mystifying. If you search http://groups.google.com for

transferspreadsheet "error 3027" group:microsoft.public.access.*

you'll find what previous explorers have recorded.