I am trying to run a macro that will export a table into a fixed length
file (see below). However, when I run it, I get the following error:
"Cannot update. Database or object is read-only." I've tried a few
things that I found in postings, but I'm not getting anywhere. Please
advise on what I can do.
'------------------------------------------------------------
' mcr_Export_Test
'
'------------------------------------------------------------
Function mcr_Export_Test()
On Error GoTo mcr_Export_Test_Err
DoCmd.TransferText acExportFixed, "Test Export Specification",
"TestTable", "C:\Documents and Settings\DK\Desktop\test.dat", True, ""
mcr_Export_Test_Exit:
Exit Function
mcr_Export_Test_Err:
MsgBox Error$
Resume mcr_Export_Test_Exit
End Function