I have written a module that uses "Application.FileSearch" to scan my
hard drive for .MDB files. It then appends the filenames (including
path) along with the file size to a table. Along with the .mdb's that
actually exist, it returns and appends the path to a database called
"db1.mdb" that doesn't actually exist so I get a run-time error when
trying to append the file size to the table.
How do you check to see if a file exists before referencing it?
Why do you suppose this phantom .mdb is being "found"?