How to connect the microsoft access database using HTML page

mazenbluee · Sep 15th, 2007, 10:18

Dear All
i have create a database using microsoft access 2000 , and i want to query this database using an HTML page , so could any one send me the required code for connecing the MS access database with the HTML page.

alexgeek · Sep 15th, 2007, 11:32

Quote:

Originally Posted by mazenbluee

Dear All
i have create a database using microsoft access 2000 , and i want to query this database using an HTML page , so could any one send me the required code for connecing the MS access database with the HTML page.

HTML is not dynamic,
therefore you need to use an ASP page

mazenbluee · Sep 15th, 2007, 12:19

ok thnaks
then what is the necessary ASP code to connect to the database

alexgeek · Sep 15th, 2007, 12:27

be best to learn ASP first.
to know how to manipulate database data
whichever you choose,
w3schools teaches all!
http://w3schools.com/asp/default.asp

robbied72 · Sep 20th, 2007, 10:46

As alex said learn some ASP as you will need to know how to query the database, once you have done that then get a connection string from here.

mkhizess · Nov 21st, 2007, 06:49

Quote:

Originally Posted by robbied72

As alex said learn some ASP as you will need to know how to query the database, once you have done that then get a connection string from here.

<html>
<head>
<title>Entitled Document</title>
<script language="JavaScript" >

function getSubmit()
{
var LastName;
var Firstn = names.value ;

var cn = new ActiveXObject("ADODB.Connection");
//here you must use forward slash to point strait
var strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source = C:/clientDB.mdb";
var rs = new ActiveXObject("ADODB.Recordset");
//var SQL = "INSERT INTO Customers(FirstName, Surname)"
//+ " VALUES ( '"+ names.value +"', '" + surname.value +"')";
var SQL = "select Surname, DOB from Customers where FirstName = '" + Firstn + "'";

cn.Open(strConn);
rs.Open(SQL, cn);
surname.value = rs(0);
DOB.value = rs(1);
//alert(rs(0));
rs.Close();
cn.Close();

}

</script>
</head>
<body>

<input type="text" name="names" />
<input type="text" name="surname" />
<input type="text" name="DOB" />
<input type="button" value="submit" onclick="getSubmit()">

</body>
</html>