wha does this code crash access ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Dim rstSuppliers As ADODB.Recordset
Set rstSuppliers = New ADODB.Recordset
rstSuppliers.CursorLocation = adUseClient
rstSuppliers.Open "Select * From Suppliers", _
CurrentProject.Connection, adOpenKeyset, adLockOptimistic
Set Me.Recordset = rstSuppliers
 
Henry said:
Dim rstSuppliers As ADODB.Recordset
Set rstSuppliers = New ADODB.Recordset
rstSuppliers.CursorLocation = adUseClient
rstSuppliers.Open "Select * From Suppliers", _
CurrentProject.Connection, adOpenKeyset, adLockOptimistic
Set Me.Recordset = rstSuppliers
Click to expand...

It doesn't for me.

Do you mean you are getting a VBA runtime error, or the Access process
itself is crashing?

Which version of MS Access? Which line of code causes the crash?

Ed Metcalfe.
 
Back
Top