Check for Path Validity 1

[gr8whitewaldron]

I am working on a database in which the user types in a path and the corresponding database is linked, processed, and deleted. I want check if the path actually does point to a file or not, in the case of misspellings or what have you. Is there a VB function for this?

 

[zrzr]

you can try the Dir function :

dim str as string
str = Dir(yourPath)

If the path doesn't exists, the function will return ""
Else ... I don't really remember, it just return something different from ""

 

[gr8whitewaldron]

Thanks, that works well.