I'm using the following code to make sure that a specific file exists.
On Access 2003 it works fine but on Access 2007 I get an error 2455 on the "FileSearch".

  Set fs = Application.FileSearch
  With fs
     .LookIn = "C:\Windows"
     .FileName = "HebDates.DLL"
     If .Execute > 0 Then
     Else
         MsgBox "File is missing"
         Application.Quit
         Exit Sub
     End If
  End With

Appendix G in Access 2007 VBA Programmer's Reference states:

"FileSearch object:
This object has been deprecated in Office 2007. You should use the FileSystemObject instead."

http://wrox.books24x7.com

Did that help?




mmcdonal

Thank you mmcdonal, It Helped.:)