[AccessD] changing to A2K: error in import

Mitsules, Mark S. (Newport News) Mark.Mitsules at ngc.com
Tue May 11 10:56:50 CDT 2004


True...my apologies.  "Shell" was stuck in my mind because I was recently
working on that ShellExecute situation.



Mark



-----Original Message-----
From: Gustav Brock [mailto:gustav at cactus.dk] 
Sent: Tuesday, May 11, 2004 11:47 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] changing to A2K: error in import


Hi Mark

No need to "shell out" to do that ...

/gustav


> Two work-arounds come to mind.

> First:
> shell out
> rename the file
> complete the transfer
> shell out
> rename the file back again

> Second:
> shell out
> copy the file to a temp file with .txt extension
> complete the transfer
> shell out
> kill the temp file



> Mark


> -----Original Message-----
> From: pedro at plex.nl [mailto:pedro at plex.nl] 
> Sent: Tuesday, May 11, 2004 12:02 PM
> To: accessd at databaseadvisors.com
> Subject: [AccessD] changing to A2K: error in import


> 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.

-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list