How do I check to see if file exists in assess 2003 query?

[jack mcfadden]

In access 2000 I used the Dir function to return a null string. It appears
that Dir is not valid in access 2003 query expressions.

 

[Allen Browne]

It is valid, unless you mutilated your Access by setting it sandbox mode.

Microsoft's explanation of what sandbox mode is and how to disable it:
http://office.microsoft.com/assista...3&CTT=8&Origin=EC011081751033&Product=acc2003

 

[jack mcfadden]

Allen,
Thank you for a quick, accurate and very helpful response.
Jack