wha does this code crash access ?

H

Henry

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
 
E

Ed Metcalfe

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top