var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: deleting linked text file entries
I would like to take an external text file which is being populated by another process, and put those text records into an Access table. This is not a problem.
Once the records are put into Access I'd like to remove the entries from the linked text file.
If I try to manipulate (change or delete) any existing records in the linked table I get an error saying that the isam doesn't support the action that I'm trying take.
Would it be possible to alter the linked table information via a module and VB code.
I'm just really hoping to not have to remember to clean the text file (via Notepad) from time to time -
Thanks for you suggestion/comments,
What happens if you delete the textfile and re-make it?
Would rather not - right now the orginal file is being created via a required testing process - but that is a possible solution.
Ok, how's about this. Replacing the existing file with a blank template (therefore no deletion required).
Aternatively you will have to utilize the FileSystemObject and TextStream methods to manipulate the file.
If the file is linked via an ISAM driver - and I believe it is - you CANNOT edit the data. This includes links to Excel files, txt, ascii, etc.
Geo is probably right , can you not just recreate the file with the data that you want to export or append to the file using the filesystem object?
Dale Houston, TX