FileSearch Application Access97-Windows 2000
Posted on 2002-07-09
I use the VBA facilities of Access 97 to validate data in CSV files. In a number of routines I use the application filesearch facility:
Set fs = Application.FileSearch
fs.Lookin = Pathroute' route to files on the server
fs.FileName = FileSpec ' Filenames e.g. "*.txt"
If fs.Execute(SortBy:=msoSortbyFileName, SortOrder:=msoSortOrderAscending) > 0 Then etc.
to identify the files stored in different folders on our server. It all works fine using our corporate WINNT operating system, however, we are moving over to Windows 2000 and it doesn't like the filesearch application, particularly the fs.Filename in the above example. A conversion to Access 2000 interferes with other multiuser dbases that are OK on WINNT and Win 2000 and Access97.