Is there any way to have Access 2000 erase a disk? I can do it through a button or would like to also try doing it on something else. I have a module that runs and imports a txt file from a disk and puts it in a table. I would like to wipe out the disk once the tabel has been uploaded. Sometimes the person who gives me the disk may have put other files on there so I want it to delete everything.
The file I am given is the same name everyday. I dont want to risk them not saving the data and seeing the old file on there and think it is the new one. I would like Access to simply format the disk once it is done uploading the data.
The problem is taht i am about to hand this database over to the people who give me the disk. I dont want to risk them using the old file obne day. I want to ensure when they go to upload the data, they arent using an old file. If I could have access format the disk once they upload the data, I wont have to worry about that.
it prompts the user for the disk. Will that do? There's probably an option for not prompting. If there's not you could write a loop to get the name of each directory and delete them one by one. Not quite formatted but as good as.