Subject: Can 't update a Access 2002 form 's ado recordset through odbc 2007-08-24 - By RAPPAZ Francois
Back
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.
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 "ODBC;DSN=mysql_dokpe_i01_adm;UID= ... ;PWD= ... ;DATABASE=dokpe
_i01"
With Cn
.Provider = "MSDASQL"
.Properties("Data Source").Value = strConnection
.Open
End With
sql = "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 = adUseClient
rec.Open sql, Cn, adOpenKeyset, adLockOptimistic
If Not rec.EOF Then
Set Me.Recordset = rec
Else
MsgBox "No data"
End If
End If
Set rec = Nothing
Set Cn = Nothing
TIA
Fran?ois Rappaz
--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=mysql@(protected)
|
|
