[AccessD] changing to A2K: error in import

Hello,

thanks to all who made clear why this error occurred and helping
with suggesting to solve the problem.

Renaming the file and name it back is a simple but effective solution.

Pedro Janssen



----- Original Message -----
From: "MartyConnelly" <martyconnelly at shaw.ca>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Tuesday, May 11, 2004 8:01 PM
Subject: Re: [AccessD] changing to A2K: error in import


> This is Microsoft being helpful, I have forgotten the exact reason. The
> behaviour may have been switched back with the latest Jet release
> However in the meantime just use the Name As statement before and after
> you call the macro to rename the file or put in a function called from
> macro.
> You will get an error if file doesn't exist or is open.
>
> Name  "C:\MyDir\MyDir2\file.gyn" As "C:\MyDir\MyDir2\file.txt"
>
> pedro at plex.nl wrote:
>
> >Hello grooup,
> >
> >i have a database in A97 that works fine. I am converting this database
to A2k and i get an error when importing a file. The import is done with a
macro with the TransferText action. I use for this an Import spec on a
filename that has an extension ".gyn". The text in this file is normal
textfile in columns. When using this macro i get an error: Cannot update.
Database or object is read-only. I double checked, nothing is read only. In
A97 this works fine. In A2k it only works when changing the extension to
".txt" (the file and the FileName in the macro).
> >
> >How is this possible?
> >I don't want to change the extensions of the filenames to ".txt., because
these extensions helps me to keep files separated for different macro's and
different actions.
> >
> >
> >Pedro Janssen
> >Cytologist
> >
> >
>
> --
> Marty Connelly
> Victoria, B.C.
> Canada
>
>
>
> --
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>