form1.frm

vb 数据库工程

VERSION 5.00
Begin VB.Form Form1 
   Caption         =   "Form1"
   ClientHeight    =   7590
   ClientLeft      =   60
   ClientTop       =   450
   ClientWidth     =   7260
   LinkTopic       =   "Form1"
   ScaleHeight     =   7590
   ScaleWidth      =   7260
   StartUpPosition =   3  '窗口缺省
   Begin VB.CommandButton Command3 
      Caption         =   "Command3"
      Height          =   495
      Left            =   3480
      TabIndex        =   6
      Top             =   2400
      Width           =   1215
   End
   Begin VB.CommandButton Command2 
      Caption         =   "NEW"
      Height          =   495
      Left            =   360
      TabIndex        =   5
      Top             =   2400
      Width           =   1215
   End
   Begin VB.TextBox Text2 
      Height          =   495
      Left            =   2640
      TabIndex        =   4
      Text            =   "Text2"
      Top             =   1320
      Width           =   1215
   End
   Begin VB.TextBox Text1 
      Height          =   495
      Left            =   2640
      TabIndex        =   3
      Text            =   "Text1"
      Top             =   720
      Width           =   1215
   End
   Begin VB.CommandButton Command1 
      Caption         =   "Command1"
      Height          =   495
      Left            =   1800
      TabIndex        =   0
      Top             =   2400
      Width           =   1215
   End
   Begin VB.Label Label2 
      Caption         =   "SS#"
      Height          =   255
      Left            =   840
      TabIndex        =   2
      Top             =   1440
      Width           =   1215
   End
   Begin VB.Label Label1 
      Caption         =   "Account Num"
      Height          =   255
      Left            =   840
      TabIndex        =   1
      Top             =   840
      Width           =   1215
   End
End
Attribute VB_Name = "Form1"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False

Private Sub Command1_Click()

Dim cnn As New ADODB.Connection
Set cnn = New ADODB.Connection
cnn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source='" + App.Path + "'\db project.mdb;Mode=ReadWrite|Share Deny None;Persist Security Info=False;"
cnn.Open









'Set cnn = New ADODB.Connection
'strCnn = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source="&App.Path&"\db project.mdb;" & "Mode=ReadWrite|Share Deny None;Persist Security Info=False;"
'cnn.Open strCnn
'MsgBox "  sfasdfafasdf"
'Set rst = New ADODB.Recordset
'rst.Open "account", cnn
'rst.MoveFirst
'MsgBox "Records:" & rst.BOF
'rst.Close
'cnn.Close

   'Dim cnn As ADODB.Connection
   'Dim rst As ADODB.Recordset
  ' Dim strCnn As String
 '  Dim strID As String
   'Dim strFirstName As String
   'Dim strLastName As String
   'Dim booRecordAdded As Boolean
' Dim rstAuthors As ADODB.Recordset
End Sub

Private Sub Command2_Click()
Form1.Hide
Form2.Show

End Sub