Application.Filesearch Access97/WinXP

[baloos]

Thanks to those people who kindly helped me with my Launching Word problem.

I have an Access 97 app which has been running fine, until I installed it on Win XP. When using .Execute() with Application.Filesearch I get the following error...

Run-time error '-2144010224 (80350010)':

Method 'Execute' of object 'FilSearch' failed

Any ideas ?

 

[ghudson]

Are you using wildcards in your file search? I had a similar problem when I upgraded from
Windows 98 to XP for an old Access 97 db that I inherited. My filesearch function was erroring
because of the * I used in my file search. I had to be more specific and use a different search
parameter. I was luck that all of my files contained the same key word within the data so I was able
to search for that word within the files data. Here is my code with the before and after changes
so maybe this will help you...

With Application.FileSearch
    .NewSearch
    .LookIn = "\\Server\Partition\Folder"
    .SearchSubFolders = False
    '.FileName = x '"ABC123.*" 'Old way
    .TextOrProperty = "ABC123"
    '.MatchTextExactly = False 'Old way
    .MatchTextExactly = True
    .FileType = msoFileTypeAllFiles [COLOR=blue]'A reference must be made to the db when selecting this option (for the first time).  Type ".FileType = " (without the quotes) and after you type the =, you will be prompted by Access if you want to add the needed reference.[/COLOR]
    If .Execute() > 0 Then

HTH