MySQL Forums
Forum List  »  Microsoft Access

Re: recordset record locking
Posted by: bob lambert
Date: October 06, 2004 03:57PM


Maybe you can answer one other Q for me. I see lots of info on creating an ADODB Connection in vb code and then creating an access recordset as follows:

Option Explicit

Private WithEvents Cn As ADODB.Connection
Private WithEvents rsRecordSet As ADODB.Recordset
Private WithEvents rstempcode As ADODB.Recordset
Dim mblnAdd As Boolean
Dim mblnEdit As Boolean
Dim strEditRec As String

Private Sub Form_Load()
Set Cn = New ADODB.Connection
Cn.CursorLocation = adUseClient
Cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source= " & App.Path & "\Accountss.mdb"
Set rsRecordSet = New ADODB.Recordset
rsRecordSet.Open "SELECT * From Salesman ORDER BY Smancode", Cn, adOpenStatic, adLockOptimistic

My code has none of this stuff. My code looks more like what you would expect for an access db:

Dim mdb as Database
Dim qd as QueryDef
Dim rstSummary As Recordset

Set qd = mdb.QueryDefs("qryrptSummary16")
qd.Parameters("[Forms]![frmReports]![ID]") = Forms!frmReports!ID.Column(0)
Set rstSummary = qd.OpenRecordset(dbOpenDynaset, dbSeeChanges)

I am using ODBC to connect to my mysql db. So how is it working w/o having to do all the ADODB connection stuff above ???


Options: ReplyQuote

Written By
October 01, 2004 07:40PM
October 04, 2004 02:24PM
October 06, 2004 02:55PM
Re: recordset record locking
October 06, 2004 03:57PM
October 06, 2004 04:09PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.