Article ID: 153017
Article Last Modified on 7/15/2004
Set MSRDC1.Resultset = Nothing MSRDC1.ResultsetType = 1 MSRDC1.Refresh
Private Sub Form_Click()
Dim cn As rdoConnection
Dim rsTemp As rdoResultset
Set cn = rdoEnvironments(0).OpenConnection("", rdDriverNoPrompt, _
False, "DSN=MyDSN;database=pubs;uid=<username>;pwd=<strong password>;")
Set rsTemp = cn.OpenResultset("Select * From Authors;", _
rdOpenKeyset)
Set MSRDC1.Resultset = rsTemp
MSRDC1.Refresh
Set MSRDC1.Resultset = Nothing
MSRDC1.Refresh
End Sub
Additional query words: 4.00 vb4win vb432
Keywords: kbbug kbdatabase KB153017