Error message when you try to run the FileSearch function in Access 2007: "You entered an expression that has an invalid reference to the property FileSearch"

To programmatically search for a file in Access 2007, you can use either the Dir function or the FileSystemObject class.

For more information about the Dir function, visit the following Microsoft Web site:
The FileSystemObject class was originally created for the Microsoft Visual Basic Scripting Edition. The FileSystemObject class is not included in the Visual Basic for Applications object library. To use the FileSystemObject class, you must select Microsoft Scripting Run-time (Scrrun.dll) in the References dialog box for the project.

For more information about the FileSystemObject class, click the following article numbers to view the articles in the Microsoft Knowledge Base:

186118 How to use FileSystemObject with Visual Basic

185601 How to recursively search directories by using FileSystemObject