Read Only Error 1

[trudye10]

Hi Guys, I'm having a problem with an Export. I read in FAQ that if the path+Filename is too long (> 64 chars.) that this will cause error 3027 (which is what I am getting).

I changed the path+filename to 40 bytes and still I'm getting 3027. I checked the database and table properties and neither one is read only.

Any ideas? suggestions? comments? concerns?

Here is my code:
Function TstExport()

On Error GoTo WhyMe
DoCmd.TransferText acExportDelim, , "tblEnroll_Error_Report", "E:\marketing\ResultsControl\PDEnroll.xls", True

Exit Function
WhyMe:
MsgBox ("Error Number: " & Err.Number & " | Error Description: " & Err.Description)

End Function

 

[Remou]

Why TransferText? Surely this should be TransferSpreadsheet? Access can be fussy about unknown extensions.

 

[Crowley16]

have you checked the permissions on the folder you're trying to export to?

--------------------
Procrastinate Now!

 

[trudye10]

You are correct O' wise one. At first I pooh-pooh'd your response, I apoligize for doubting your wisdom it was infact a read-only restriction on the folder.

Thanx to all who responded,
Trudye