How can I determine is a file is resident ??? 1

[Dylan]

Iam using access 97 and need to figure out how to write some code that will determine whether a file exists on a network drive prior to writing code to do an importtext type of function. I have been looking at the FileSearch object but have not been able to get it to work.<br>
Is there an easy way of doing this ????<br>
<br>
Thanks in Advance ...

 

[bitbrain]

Use the Dir function. An empty string will be returned if the file does not exist. Sample follows:<br>
<br>
strMsg = Dir(strArgPath)<br>
<br>
If strMsg = "" Then<br>
error...<br>
<br>
<br>