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