Search and display

[Jack]

I need to search a database for individual files (about
50) and need an automated process that will display the
path to each file in the database structure if it exists.

Does anyone have an example or have any suggestions to do
this?

Thanks
Jack

 

[[MVP] S. Clark]

The FileSystemObject will allow this. See the online help for examples. It
is quite simple to use.

Also, Total Visual Sourcebook has code to do this.
http://www.fmsinc.com/products/sourcebook/index.html


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-