Seth Galitzer
sgsax at ksu.edu
Mon Mar 10 13:31:00 CST 2003
Rocky, Dump TransferText like a bad prom date and use file I/O manually to generate your text file. You have much more control of the output and I have NEVER had it fail on me. I've got sample code on my website. Look under Downloads for "File I/O in VB". There should be enough there to get you started. I'd be happy to answer any questions if you have any. Seth On Mon, 2003-03-10 at 12:07, Rocky Smolin - Beach Access Software wrote: > Dear List > > I'm trying to use the TransferText method of exporting a table to a comma delimited file. I get "Error 3027: Cannot Update. Database or object is read-only" when issuing: > > DoCmd.TransferText acExportDelim, , "tblAddRooms", varFileName > > where varFileName contains a valid path and file name. Has anyone seen this before? I have but can't remember why or what the fix was. > > MTIA, > > Rocky Smolin > Beach Access Software > > -- Seth Galitzer sgsax at ksu.edu Computing Specialist http://puma.agron.ksu.edu/~sgsax Dept. of Plant Pathology Kansas State University