Transfer Text not working correctly

[Phil5673]

I have the following code to transfer a table to a text file. I am getting an error message "Database or object is read only." I am not sure what could be causing this. The database is not read only and the table is not read only. Any feedback is appreciated.

strPath = strFolderName & "\" & strRRDD & CStr(Month(Date)) & CStr(Day(Date)) & CStr(Year(Date)) & "tblTrackingNumbers"
DoCmd.TransferText acExportDelim, "ExporttblTrackingNumbers Export Specification", _
"ExporttblTrackingNumbers", strPath, -1

Phil Edwards

 

[PHV]

Have you sufficient permissions on strFolderName ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Phil5673]

Yes. I have already checked that option. I get this message regardless of sufficient privileges.

Phil

 

[AlanJordan]

May I suggest that you try the TransferSpreadsheet method, and see if that is working for you. Sometimes the TransferText method behaves strangely.

Alan