$dbname = "d:\temp\test.mdb"    ;DB파일 경로
$tblname = "TableName"    ;Table명
$query = "Update " & $tblname & " Set TestField = 2" & " WHERE TestField = 0"    ;위에 정의한 table의 TestField 필드 0값을 2로 바꿈

$adoCon = ObjCreate("ADODB.Connection")
$adoCon.Open("Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & $dbname)

$adoRs = ObjCreate ("ADODB.Recordset")
$adoRs.CursorType = 1
$adoRs.LockType = 3
$adoRs.Open ($query, $adoCon)
$adoCon.Close 


http://vista.tutorialref.com/autoit/autoit-access-database.html
http://www.articlesbase.com/programming-articles/autoitconnect-to-access-databasesmdb-accdb-files-971667.html

+ Recent posts