MS Access Log in Script

[jkewlo]

ok im trying to make a check.php page but dont know how i will do it with php/ms access mysql would be a zip to do. but not ms access being its a pain in the ash

[lemmin]

$conn = new COM("ADODB.Connection") or die("Cannot start ADO"); 
$conn->Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=your db.mdb");
$query = $conn->Execute("SELECT field FROM Table");
while (!$query->EOF)
echo $query->Fields("field")->value;

Good luck!