About Jeff Allen Expertise I can answer basic to intermediate questions related to Classic ASP.I can answer Intermediate to Advanced questions CSS& HTML, and basic questions about JavaScript and Ajax. I can also answer questions related to web page accessibility under US Section 508.
Experience I have 8 years experience with HTML. I have been developing in ASP, VBScript and CSS for two years each. I also currently work as web developer.
Organizations IWA-HWG
Education/Credentials I have a BA in English with minors in Web Design and Scientific and Technical Writing
Expert: Jeff Allen Date: 11/4/2006 Subject: ASP Databases
Question I have this code to open a MS Access database:
objConn.Open "DSN=MS Access Database;DRIVER=(Microsoft Access Driver (*.mdb));DBQ=C: ups.mdb"
How do I modify this code to open a database located on a remote web server. (Someone else is hosting my website)
Answer Usually, it has been my experience that the database is often located on the D: drive of the host server and not the C: Drive, although your host should be able to answer this question for you.
What I did the last time I had to do this was create an .asp page in the same directory as my database and in that page I out something like this:
<%
Dim myPath : myPath = Request.ServerVariables("PATH_INFO") & "myDB.mdb"
