[AccessD] TransferText Failling

Seth:

I think you're right.  I was just trying to do it in one line.  I've used
direct file I/O and it's simple and straightforward, especially for an old
DOS guy like me.

If the client wants something besides .txt I'll probably convert.  This is a
real simple spit it out, read it in scenario.  Not much control required.
No specification.

Any other good reason to abandon the transfertext if it's working?

Thanks and regards,

Rocky Smolin
Beach Access Software

----- Original Message -----
From: "Seth Galitzer" <sgsax at ksu.edu>
To: "accessd" <accessd at databaseadvisors.com>
Sent: Monday, March 10, 2003 11:31 AM
Subject: Re: [AccessD] TransferText Failling


> 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
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>