How to connect to a MS Access Database

Hi everyone it's David...

I've now made a new website and you can register to become a member. The problem is how can i store the member data.

I thought of using a MS access databse with the (first name, last name, etc) fields and then using MS infopath to connect to the database.

I've done it before connecting to a databse on my hardrive but this time i've uploaded it to my website hosting server.

I know the URL of the database. But this time i can't connect using infopath. I know there is probably an easier way for me to store the data by using SQL or another language but i don't know how to use it.

Can anyone suggest what i should do.

Thanks again

David.

i come across this about a week ago, may or may not help http://www.goingware.com/tips/parame...embervars.html

__________________
My Recipe forum... For all your food needs

David,

Is your site hosted on an IIS windows server?

I don't know, it is uploaded to kawanda.net

I don't know if it is IIS or anything, but i know the direct URL to the 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.

__________________
Click the 'Thanks!' button if this post has helped you

Rob - Webforumz Founder