ajetrumpet
Banned
- Local time
- Yesterday, 18:52
- Joined
- Jun 22, 2007
- Messages
- 5,638
all,
I have a procedure that takes the contents of a DOS command line output and sends it to an Access table. the problem I am having is that after I run the portion of the code that writes the command line output to the text file, I am calling another procedure that imports the text file into my access table, BUT...it is not reading the new contents that I just put in there. It is imported the OLD contents. The text file is not being refreshed/updated before the import takes place. does anyone know how to take care of this? I can always run the 2 procedures seperately and it works fine that way, or I can refresh the windows explorer file list window that I have open when testing it, but I can't have that happen for a user. it has to be automatic in the same procedure. any help welcome. thanks all!
I have a procedure that takes the contents of a DOS command line output and sends it to an Access table. the problem I am having is that after I run the portion of the code that writes the command line output to the text file, I am calling another procedure that imports the text file into my access table, BUT...it is not reading the new contents that I just put in there. It is imported the OLD contents. The text file is not being refreshed/updated before the import takes place. does anyone know how to take care of this? I can always run the 2 procedures seperately and it works fine that way, or I can refresh the windows explorer file list window that I have open when testing it, but I can't have that happen for a user. it has to be automatic in the same procedure. any help welcome. thanks all!
