四种用代码打开外部Access(MDB)的方法
方法1:
Dim AccessPath As String
Dim DbPath As String
AccessPath = SysCmd(acSysCmdAccessDir) &"MSACCESS.EXE"
DbPath = "C:\db1.mdb"
Shell AccessPath &" " & DbPath
方法2:
Dim DbPath As String
DbPath = "C:\db1.mdb"
Application.FollowHyperlink DbPath
方法3:
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
Sub OpenBd()
Dim DbPath As String
DbPath = "C:\db1.mdb"
ShellExecute 0&, vbNullString, DbPath, vbNullString, vbNullString, 0&;
End Sub
方法4:
Dim DbPath As String
Dim oApp As Access.Application
DbPath = "c:\db1.mdb"
Set oApp = New Access.Application
With oApp
.Visible = True
.OpenCurrentDatabase DbPath
.DoCmd.OpenForm "MyForm"
.DoCmd.OpenReport "MyReport", acViewPreview
.Run "MyFuncion"
End With
Set oApp = Nothing
(责任编辑:admin)
- ·两个未公开的ACCESS方法的使用技巧
- ·如何拆分复制的Access 97数据库
- ·两个未公开的ACCESS方法的使用技巧
- ·用Access 2000有效地组织班级管理
- ·数据在Access与Office组件间自由流动
- ·Access"智库"培训--高效设计 敏捷开
- ·Access查询的基本知识(二)(Office免费
- ·Access设置宏的安全等级
- ·Access查询的基本知识(Office免费公开
- ·四种用代码打开外部Access(MDB)的方法
- ·access操作或事件已被禁用模式阻止的解
- ·简述vba字符串,函数,表达式等基础术
- ·Access VBA 开发公开课讲座
- ·Access设置信任位置
- ·Access应用程序应注意的几个问题
- ·简析能判断Access版本的窗体