How to write into a mdb database

[GuilleRF]

After a couple of weeks searching on how to do this.. and trying to install sqlite unsuccesfully... I have decided to show you m code to see if ou can give me any help.

 

I am making a small code justo to write into an existing database and to read from it. I am able to write into it with this code:

$dbname = "BBDD.mdb"
$tblname = "Clientes"
Global $adoCon = ObjCreate ("ADODB.Connection")
$query = "SELECT Nombre FROM Clientes"
$adoCon.Open("Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & $dbname)
$adoRs = $adoCon.Execute($query)
Dim $output
While Not $adoRs.EOF
   $output = $output & $adoRs.fields("Nombre").value & @CRLF
   $adoRs.MoveNext
WEnd
$adoCon.Close
ConsoleWrite($output)

And following with this type of coding I wrote this code to write into the database:

$dbname = "BBDD.mdb"
$tblname = "Clientes"
Global $adoCon = ObjCreate ("ADODB.Connection")
$adoRs = ObjCreate ("ADODB.Recordset")
$adoRs.CursorType = 2
Dim $name = "hola"
$query = "INSERT INTO Clientes (Nombre, Apellido1, Apellido2, Telefono, Mail, Fecha) Values ("&$name&", ere, ere, eee, erer, ere);"
ConsoleWrite($query)
$adoCon.Open("Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & $dbname)

$adoCon.Execute($query)
$adoCon.Close

When executing I get the following in the console:

 

INSERT INTO Clientes (Nombre, Apellido1, Apellido2, Telefono, Mail, Fecha) Values (hola, ere, ere, eee, erer, ere);"C:\Users\Guillermo\Documents\kk2.au3" (11) : ==> The requested action with this object has failed.:
$adoCon.Execute($query)
$adoCon^ ERROR

please send me any advice

 

 

[water]

Welcome to AutoIt and the forum!

Did you have a look at the wiki? There you find UDFs for MS Access and ADO in general.