Need: Access DB to Browser in 8 hours

[agoodeill]

Ok, Now I am sweating... Is there anyone that can help? If I send you a database, can you write a page to pull the the DB into a webpage? I need to get something completed by tonigh, and I am sooo new to this, I will not beable to learn it and create in in 8 hours. Pleeese!

Anthony🙁

[weekender]

why don't you use a ms access data access page - read about them in access help.

sorry i can't be more helpful.

[vivianp79]

I wrote you a response to this question under the Coding forum. Please have a look at it. It has some code you can use.

[jimson]

class db{
function open($dbPath, $dbPwd="defaultPassword"){
$db = new COM("ADODB.Connection");
$conn = "DRIVER={Microsoft Access Driver (*.mdb)};";
$conn .= "DBQ=$dbPath;uid=;pwd=$dbPwd;";
return $db;
}
}

to execute the sqlstatement
then use
$db = new db();
$conn = $db->open("database/database1.mdb", "password");
$rs = $conn->execute("SELECT * FROM TABLE1");

while(!$rs->EOF){
echo $rs->fields["TABLE1COL1"]->value;
echo $rs->fields["TABLE1COL2"]->value;
echo $rs->fields["TABLE1COL3"]->value;
echo "<br>";
}