To find your physical path, enter this in a page
response.write(server.MapPath("/"))
This will show you the physical path to your root directory.
My hosting company has all web content in a folder called htdocs, and then parallel to this is a folder called private. So whenever I want to access a file in the private area I use something like:
strRootPath = Server.MapPath("/")
strDbPathAndName =((Left(strRootPath,len(strRootPath)-6)) & "private/wwForum.mdb")
There should be 2 lines above, but the second has wrapped so be sure to enter it all on one line.
I'm no ASP expert, but what this does is a) get the physical path to the root of the web site. Then b) find the length of that path and remove 6 (the number of characters in htdocs) This gives me the physical path to the root of my hosted web space. I can then add on the folder and database name that I am interested in.
Why go to all this trouble? Because I can use the same code on any of my sites, and the physical path may change, but I can always find my databases no matter which site it is, or which folder the asp is running in.