[AccessD] TransferText Failling

Hi Rocky,

What is the extension of the filename you are trying to export to? Remember 
that Access is particular about that and will only export to .txt or .csv or 
.tab or a couple other magic extensions.

Gary Kjos
garykjos at hotmail.com


>From: "Rocky Smolin - Beach Access Software" <bchacc at san.rr.com>
>Reply-To: accessd at databaseadvisors.com
>To: <AccessD at databaseadvisors.com>
>Subject: [AccessD] TransferText Failling
>Date: Mon, 10 Mar 2003 10:07:04 -0800
>
>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
>
>


_________________________________________________________________
MSN 8 with e-mail virus protection service: 2 months FREE*  
http://join.msn.com/?page=features/virus