468,309 Members | 1,201 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,309 developers. It's quick & easy.

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

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

Feb 1 '06 #1
0 1807

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Sorisio, Chris | last post: by
6 posts views Thread by juli | last post: by
reply views Thread by Matthew Louden | last post: by
1 post views Thread by Sivaprasad | last post: by
2 posts views Thread by =?Utf-8?B?S3Jpc2huYQ==?= | last post: by
reply views Thread by NPC403 | last post: by
reply views Thread by Teichintx | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.