File Exists (On NetWork)

[Evan]

Originally posted by geoff_xrx
why not use the Dir() function?

MyCheck = FileExists("\\Eduardo\c\WINNT\customerinfo.mdb") 
 
Private Function FileExists(FullFileName As String) As Boolean 
If len(Dir(FullFileName,vbNormal)) = 0 Then FileExsist = False Else FileExisit = True
End Function

Thats what I was using. It wont work over the network.
and yes, the other way does slow my program down.

if that file is LARGE then your app will slow down if the file does exsist. it will have to open it over the network, then just close it.

this just checks the length of the file