Export read only error (1 Viewer)

[TVReplay99]

I am trying to automate my Table export process and have been getting the error message: "Cannot Update. Database or Object is Read-Only.'
None of the the Tables are read only, I'm not sure they even could be. Here is the code I am Using:
Private Sub btnExportTest_Click()
DoCmd.TransferText acExportFixed, "HazTrakExportSpecs", "tblHazTrak", "C:\Documents and Settings\nancy\Desktop\Brian\ExportTest", False
End Sub

I got this code from searching this site and the Access Help.

This is the final piece to my DB. Any input would be greatly appreciated.

Brian

 

[ghudson]

I did notice that you do not have the text file extension at the end of your string...

DoCmd.TransferText acExportFixed, "HazTrakExportSpecs", "tblHazTrak", "C:\Documents and Settings\nancy\Desktop\Brian\ExportTest.txt", False

Also, do you have permissions to write a file to the \Nancy\ and or \Brian\ directories? I prefer to write to the \All Users\Desktop\ directory for just that reason.