Good Afternoon:
I am trying to run a Transfertext, but keep getting a Run-time error '3027': Cannot Update. Database or object is read-only.
I am not sure if this is a Windows issue or an Access related problem. I can Insert into a table in the same director, but cannot Transfertext. The sub directory that I am trying to output to is empty. When I look at the properties of the subfolder, parent folder, and even the network drive it is Read-only, but I can save to it from from any other program. Here is my Transfertext:
Code:
strFileName = "<Path>\<File Name>_" & dteTodayDate
DoCmd.TransferText acExportDelim, "", "tempExport", strFileName, False, ""
Is it something that I did, or Windows? I should also note that the tempExport table is a linked table and not a local table (if this makes any difference).