Find a database file on C drive and pass location to another database?

[gdmorton]

I am just getting into learning VBScript and I am wondering if I can use the FileSystemObject to locate a database on the c drive of a users PC and then pass the path to another database to use in replaceing a form. I know the database file I am trying to locate is located on the c dirve and I know the name of the file, I just don't know what folder and/or subfolder it might be located in on the users machine.

I know it is probably possible to locate the file (need help with the code), but is it possible to pass that location to another database using VBS?

 

[PHV]

And what have you so far ?

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884