Private Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" (ByVal hwnd As Long, ByVal lpOperation As String, ByVal lpFile As String, ByVal lpParameters As String, ByVal lpDirectory As String, ByVal nShowCmd As Long) As Long Private Sub Command1_Click() ShellExecute Me.hwnd, "open", "你的mdb文件路径", vbNullString, vbNullString, 3 End Sub
不过你要双击打开表的话,我建议你引用access对象: 首先加入对 Microsoft Access 9.0 Object Library的引用: Dim aC As New Access.ApplicationPrivate Sub Command1_Click() aC.OpenCurrentDatabase ("D:\MC\FPNWIND.MDB") aC.Visible = True aC.DoCmd.OpenTable "客户" End SubPrivate Sub Form_Terminate() Set aC = Nothing End Sub
Private Sub Command1_Click()
ShellExecute Me.hwnd, "open", "你的mdb文件路径", vbNullString, vbNullString, 3
End Sub
首先加入对 Microsoft Access 9.0 Object Library的引用:
Dim aC As New Access.ApplicationPrivate Sub Command1_Click()
aC.OpenCurrentDatabase ("D:\MC\FPNWIND.MDB")
aC.Visible = True
aC.DoCmd.OpenTable "客户"
End SubPrivate Sub Form_Terminate()
Set aC = Nothing
End Sub