Filesearch object misses zip files

[Bob]

The following code finds all types of files except zip
files. Does anyone know why and whether there is a fix of
some sort?

With Application.FileSearch
.FileName = "Example.zip"
.LookIn = sExportDirectory
if .Execute() >0 then
ynFoundFile = True
End If
End With

I am using AccessXP with WindowsXP with latest service
updates applied. It used to work with Access97 / Win98 and
I am upgrading the application.

Thanks

 

[TC]

You surely do not mean that the code as shown, finds all files excrept zip
files?

Are you sure the string variable contains what you think it does?

Does the FileSearch object have any properties which might have held-over
from a previous use (& prevent it working the second time, or some-such)?

HTH,
TC

 

[Bob]

Yes I do. I tested it with all possible fixes/workarounds -
it definitely works on anything but zip files.

I now find that Filesearch doesn't work at all using
Access 2002 runtime (although it does if the full product
is installed). I have tried it on both WinXP and Win98
boxes. Great isn't it!!!! Now what do I do?

 

[Bob]

Yes I do. I tested it with all possible fixes/workarounds -
it definitely works on anything but zip files.

I now find that Filesearch doesn't work at all using
Access 2002 runtime (although it does if the full product
is installed). I have tried it on both WinXP and Win98
boxes. Great isn't it!!!! Now what do I do?