Locate another database on C drive an update a form in it?

[gdmorton]

I am beginning to learn VBA in Access and am needing to create some code within one database that will locate another database stored somewhere on the C drive and then delete an old form and replace it with a new version of that form. I know how to do the part of deleting the form and then replacing it with the new version, I am just not sure how to locate the database that has the old form. I know it is on the c drive and I know what it is named but I don't know where it might be located on all us the end users machines. I need to locate it and then pass the location path to the code that will delete the old form and replace with the new.

Any help?

 

[vbajock]

Google "FileScriptingObject". With it, you can scan the entire hard drive for a file.

 

[PHV]

Depending of your version of access you may consider Application.FileSearch

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