Macro error "Cannot update. Database or object is read-only."

[mvdkwong]

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.TransferT ext acExportFixed, "Test Export Specification",
"TestTable" , "C:\Documen ts and Settings\DK\Des ktop\test.dat", True, ""

mcr_Export_Test _Exit:
Exit Function

mcr_Export_Test _Err:
MsgBox Error$
Resume mcr_Export_Test _Exit

End Function