.lookin error

[Nishikawa]

This is the first time that I encounter this problem and I do not know the source of it, I hope someone can shed some light on it.

I was using .lookin for a file search

With Application.FileSearch
.NewSearch
.LookIn = f.path
.SearchSubFolders = False
.filename = "*.txt"
.MatchTextExactly = False
.FileType = 1 'msoFileTypeAllFiles

f.path is a path that I reference to my server.

The problem is that no matter where I reference, ".lookin" just searches C:\Documents and Settings\All Users

Does anyone encounter this before? If so, how did you fix it?

 

[James Dudden]

Have you tried swapping f.path with the actual path that you want?

Just a thought

 

[Brianwarnock]

I am pretty sure that James is correct, if you don't quote a full path then it searches as you saw for the dataset f.path.

Brian

 

[Nishikawa]

Yup, I tried that. I even tried the same application (i copied the access database to a thumb drive) on three other computers and it worked like a charm. Only that particular computer does not seem to recognise f.path or the actual path.