>Hi friends
>just wondering whats the fastest way to find if a file exist and if so open it.
>the reason ask we've some clients with more 100,000 docs which can be accessed thru our app.
>at the moment find a file and opening a file taking noticeable time.
>btw we are using "file()" command at the moment

Just to add - you could write a VFP app which would monitor these directories for change (haven't done that yet, but it's been mentioned around here) and keep the current filenames in a table. Then your main app would simply consult this table, not the directory. The table could even contain some keywords, creation date, last change date and other clues to find a document faster. Once it's found in the table, you know the exact filename and just open the file.