Can"t update a Access 2002 form"s ado recordset through odbc

According to Miscrosoft docs at =
http://support.microsoft.com/kb/281998/EN-US/, it seems that a form's =
ado recordset with access 2002 should be updatable using ODBC.=20

However, with a form in a mdb file with the access 2002 format, I still =
have the "recordset is not updatable" message ... Is there anyone who =
have managed this ?

I use mysql and Connector/ODBC 3.51.

I tried the following code on AfterUpdate of a text control: sSearch is =
a string with the words being searched for.

Dim Cn As New ADODB.Connection
Dim rec As New ADODB.Recordset
Dim strConnection As String, sql as String

strConnection =3D
"ODBC;DSN=3Dmysql_dokpe_i01_adm;UID=3D ... ;PWD=3D ... =
;DATABASE=3Ddokpe_i01"
With Cn
.Provider =3D "MSDASQL"
.Properties("Data Source").Value =3D strConnection
.Open
End With

sql =3D "select concat(nofm, '') as nofm, ti, tri, issn, ex, ad,
concat(noed,'') as noed, dom from jrn where match(ti) against(" &
Chr(39) & sSearch & Chr(39) & " in boolean mode)"
rec.CursorLocation =3D adUseClient
rec.Open sql, Cn, adOpenKeyset, adLockOptimistic

If Not rec.EOF Then

Set Me.Recordset =3D rec

Else
MsgBox "No data"
End If
End If
Set rec =3D Nothing
Set Cn =3D Nothing

TIA
Fran=E7ois Rappaz


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=3Dgcdmo-myodbc@m.gmane.o rg

RE: Can"t update a Access 2002 form"s ado recordset through odbc

Francois:

I work with msaccess 2000 and mysql 4.0.12 and Works really good. You =
need
to put a column type timestamp so access can check the row has not been
modified.

There are several other threds with this problem, check them out.

Osvaldo Sommer

-----Mensaje original-----
De: RAPPAZ Francois [mailto:francois.rappaz@unifr.ch]=20
Enviado el: Viernes, 24 de Agosto de 2007 12:41 a.m.
Para: myodbc@lists.mysql.com
Asunto: Can't update a Access 2002 form's ado recordset through odbc


According to Miscrosoft docs at
http://support.microsoft.com/kb/281998/EN-US/, it seems that a form's =
ado
recordset with access 2002 should be updatable using ODBC.=20

However, with a form in a mdb file with the access 2002 format, I still =
have
the "recordset is not updatable" message ... Is there anyone who have
managed this ?

I use mysql and Connector/ODBC 3.51.

I tried the following code on AfterUpdate of a text control: sSearch is =
a
string with the words being searched for.

Dim Cn As New ADODB.Connection
Dim rec As New ADODB.Recordset
Dim strConnection As String, sql as String

strConnection =3D
"ODBC;DSN=3Dmysql_dokpe_i01_adm;UID=3D ... ;PWD=3D ... =
;DATABASE=3Ddokpe_i01"
With Cn
.Provider =3D "MSDASQL"
.Properties("Data Source").Value =3D strConnection
.Open
End With

sql =3D "select concat(nofm, '') as nofm, ti, tri, issn, ex, ad,
concat(noed,'') as noed, dom from jrn where match(ti) against(" &
Chr(39) & sSearch & Chr(39) & " in boolean mode)"
rec.CursorLocation =3D adUseClient
rec.Open sql, Cn, adOpenKeyset, adLockOptimistic

If Not rec.EOF Then

Set Me.Recordset =3D rec

Else
MsgBox "No data"
End If
End If
Set rec =3D Nothing
Set Cn =3D Nothing

TIA
Fran=E7ois Rappaz


--=20
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:
http://lists.mysql.com/myodbc?unsub=3Dosommerh@intelnett.com



--=20
No virus found in this incoming message.
Checked by AVG Free Edition.=20
Version: 7.5.484 / Virus Database: 269.12.6/971 - Release Date: =
24/08/2007
02:59 p.m.



--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=3Dgcdmo-myodbc@m.gmane.o rg