VBA code to allow writing to file in c:\ in Vista?

[Guest_imported]

Visa won’t allow accessing/storing a file on C:\ unless it’s READ-ONLY, so now we need to store our database file in the following path: c:\username\engl\engl.mdb (it used to be the pathname c:\engl.mdb).

We have a lot of VBA code that calls (Opens) the database in c:\engl.mdb in Windows XP (and Office XP). What’s the best VBA code to make this now work in Vista, given that the username will be changing as well? It would be great if we could do a simple Find/Replace on all the modules that reference c:\engl.mdb.

Thanks for any suggestions!

--Ray

 

[PHV]

the username will be changing as well
You may consider the Environ function:
strPath = "c:\" & Environ("username") & "\engl\engl.mdb"

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886