Public Rs As New ADODb.Recordset
Public Conn As New ADODb.Connection
Private Sub cmdAdd_Click()
On Error Resume Next
Rs.AddNew
End Sub
Private Sub cmdCancel_Click()
Unload Me
End Sub
Private Sub cmdDel_Click()
On Error Resume Next
Rs.Delete
End Sub
Private Sub cmdOk_Click()
Rs.UpdateBatch
Unload Me
End Sub
Private Sub Form_Load()
Call Make_connection
If Rs.State <> adStateClosed Then Rs.Close
Rs.Open "select * from Man", Conn, adOpenStatic, adLockBatchOptimistic
Set Me.DataGrid1.DataSource = Rs
End Sub
Public Sub Make_connection()
Dim strConn As String
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\People.mdb;Persist Security Info=False"
Conn.CursorLocation = adUseClient
Conn.Open strConn
End Sub
Private Sub Form_Unload(Cancel As Integer)
If Rs.State <> adStateClosed Then Rs.Close
Conn.Close
Set Rs = Nothing
Set Conn = Nothing
End Sub