AutoIt-Access Database 2007 Accdb

I’m trying to find out if there is an AutoIt capability to connect to a MS Access database and particularly with Access 2007 and an .accdb file. I’ve tried the following which I found the core from a forum but I couldn’t get it to work. So I’m just posting this problem now and will post a solution once I find it myself. If you know the solution then please post your reply here. The forum stated the code was working with MS Access 2000 but there is probably not too many people with that version nowadays.

$dbname = "C:\Users\vk\Documents\db\Marketing\articleSubmissionsTutorialRef.mdb"
$tblname = "articles"
$fldname = "UserName"
$query = "SELECT * FROM " & $tblname & " WHERE articleID = '4'"
Dim $_output
$adoCon = ObjCreate("ADODB.Connection")
$adoCon.Open("Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & $dbname)
;$adoCon.Open("Driver={Microsoft Access Driver (*.accdb)}; DBQ=" & $dbname)
$adoRs = $adoCon.Execute($query)
While Not $adoRs.EOF
	$_output = $_output & $adoRs.fields("title").value & @CRLF
	$adoRs.MoveNext
WEnd
$adoCon.Close
MsgBox(0,"Guest List",$_output)

These are the errors I receive:

>Running:(3.3.0.0):C:\Program Files\AutoIt3\autoit3.exe "C:\Program Files\AutoIt3\SciTE\test_access.au3"    
### COM Error !  Number: 80020009   ScriptLine: 46   Description:[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.
### COM Error !  Number: 000000A9   ScriptLine: 47   Description:[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.
C:\Program Files\AutoIt3\SciTE\test_access.au3 (48) : ==> Object referenced outside a "With" statement.:
$_output = $_output & $adoRs.fields("title").value & @CRLF
$_output = $_output & $adoRs.fields("title")^ ERROR
->03:03:46 AutoIT3.exe ended.rc:1
+>03:03:47 AutoIt3Wrapper Finished

I tried the above with both accdb and mdb files. Will update the answer on another post.

Share and Enjoy:
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Mixx
  • Google Bookmarks
  • Share

You must be logged in to post a comment.