MkDir command

[tylerg11]

I'm using the MkDir command to create folders with VBA. It works well, and I'm checking to see if the folder exists. If it doesn't, I create it.



Just want to make sure that I can't accidently overwrite a folder with this command. From what I've seen through testing, an error will pop up if I try to make a directory if it already exists. Just checking..

[orange]

I think you are correct. If you attempt to MkDir a directory that already exists, an error is generated.
Also, if I recall correctly, you can only doa MkDir at one level at a time. It's been a few years since I worked with this in Access, but I had to make things like C:\MyDir, then C:\MyDir\sub1\ in incremental steps.

I did a quick google and found
http://www.techonthenet.com/access/f...file/mkdir.php

Good luck

[alansidman]

but I had to make things like C:\MyDir, then C:\MyDir\sub1\ in incremental steps.

Its been many number of years since I played with DOS commands but if I recall, that was how it was when you did this manually in DOS.