What is the preferred method of determining a file exists.

[GAORR]

I'm looking for the preferred method of determining if a file (data base) exists before running an app. I have seen different methods, such as dir, opening a file, and I suspect there are API's that will accomplish this also.

Any thoughts ?

Thanks

 

[Swi]

I prefer Dir but all methods all are acceptable and I think are just as fast.

' Initialize files
InFileName = txtInputFile.Text
OutFileName = txtOutputFile.Text
Counter = 0
Counter2 = 0

' Verify replacement of output file if it exists
If Dir(OutFileName) <> &quot;&quot; Then
Msg = &quot;Replace contents of &quot; + OutFileName + &quot;?&quot;
If MsgBox(Msg, 4, &quot;Replace File?&quot = 6 Then
Kill OutFileName
Else
txtOutputFile.SetFocus
txtOutputFile.SelStart = 0
txtOutputFile.SelLength = Len(txtOutputFile)
Exit Sub
End If
End If

 

[CajunCenturion]

You might find the .FileExists method of the FileSystemObject useful
Good Luck
------------
Select * from Users where Clue > 0
0 rows returned