View Single Post
  #5 (permalink)  
Old Aug 26th, 2006, 20:04
Rob's Avatar
Rob Rob is offline
Head Admin & CEO

SuperMember
Join Date: Jul 2003
Location: at my desk
Age: 34
Posts: 2,956
Blog Entries: 7
Thanks: 7
Thanked 4 Times in 4 Posts
Re: How to connect to a MS Access Database

If you host allows MSAccess Databases, then chances are it allows ASP.

The following will connect to a MSAccess database in ASP
Code: Select all
 <%
     set conn = server.createobject("ADODB.Connection")
    conn.open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=c:\full\path\to\file.mdb"
%>
I'm afraid, you'll need a lot more ASP than that to do anything useful, so pick up a good ASP book and dive into some examples.

Post back if you get stuck or need recommendations for reading.
__________________
Rob - SEO Specialist
Owner & Founder of Webforumz.com

I am currently unavailable for private work
Reply With Quote