04/10/2012, 10:03
accessman
bu kodu accessde nasıl kullanabiliriz
Kod:
Private Sub Form_Load()
Dim cnn As ADODB.Connection
Dim rst As ADODB.Recordset
Dim strSQL As String
Set cnn = CurrentProject.Connection
strSQL = "SELECT * FROM tblRecords"
Set rst = New ADODB.Recordset
rst.CursorLocation = adUseClient
rst.Open strSQL, cnn, adOpenStatic, adLockBatchOptimistic
Set grdDataGrid.DataSource = rst
End Sub