SysCmd?

[Turner]

I am looking for a command that will tell me if a
specific Access db is available ("C:\Path\DbName").

I had thought SysCmd was it but after reading the help
files it doesn't seem to do the job.

Thanks

Dean

 

[Dirk Goldgar]

I am looking for a command that will tell me if a
specific Access db is available ("C:\Path\DbName").

I had thought SysCmd was it but after reading the help
files it doesn't seem to do the job.

Thanks

Dean

I'm not sure what you mean by "available". If you explain that, maybe
we can suggest something.

 

[Allen Browne]

Public Function FolderExists(varPath As Variant) As Boolean
On Error Resume Next
If Len(varPath) > 0& Then
FolderExists = (Len(Dir$(varPath, vbDirectory)) > 0&)
End If
End Function