AutoIt Access Database Connection

[jagman1990]

Hello Everybody,

I am trying to connect to an Access Database using AutoIt. I googled how to connect to a database and this is the code that they gave me.

$_dbname = "C:\Documents and Settings\jgreenberg\Desktop\Peidmont.accdb"
$tblname = "Piedmont ATB"
$query = "SELECT * FROM " & $tblname & " WHERE articleID = 4"

Local $title
$adoCon = ObjCreate("ADODB.Connection")
$adoCon.Open ("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & $_dbname) ;Use this line if using MS Access 2007 and using the .accdb file extension
$adoRs = ObjCreate ("ADODB.Recordset")
$adoRs.CursorType = 1
$adoRs.LockType = 3
$adoRs.Open ($query, $adoCon)
$title = $adoRs.Fields("Account").value    ;Retrieve value by field name
;$title = $adoRs.Fields(2).value         ;Retrieve value by column number
$adoCon.Close
MsgBox(0,"testing",$title)

This is the line that keeps giving me an error. It keeps saying that The requested action with this object has failed. What should I do to fix this or is there better code that I could be using.

$adoCon.Open ("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & $_dbname)

[GEOSoft]

That connection string won't work if it's an Access 2007 database. You can download a Access UDF from the bottom f this page.

http://dundats.mvps.org/AutoIt/udf_code.aspx?udf=access