Verifying the existence of a directory

[chell]

Hello;

I'm writing an app in Access VBA and I need to verify the existence of a directory as supplied by the user. The DIR function works fine except that it won't work with something like "\\Server1\ADirectory". Does anybody have any ideas?

Thanks For The Help...
Chell

 

[dsi]

Use the Dir() function. If the directory is supposed to have files, it is real easy:

If Dir(&quot;\\Server1\ADirectory\*.*&quot;) <> &quot;&quot; Then
    'Files Are Present
Else
    'No Files
End If

If this directory can be empty, it will take a little more code. If this is the case, look into the Help for this function, or let me know and I will get to it when I have more time.

 

[tedsmith]

You can also enable the Microsoft scripting reference commands and give you all the DOS type commands like copy etc

 

[cjet]

Try If Dir(&quot;\\Server1\ADirectory&quot;, vbDirectory)<>&quot;&quot; Then
'Directory exist
End If