16,548
社区成员
发帖
与我相关
我的任务
分享How to use ADO to create Access database file?
I wonder if ADO can be used to create Access database file(*.mdb). If anyone could help me, thanks a lot.
...全文
请发表友善的回复…
发表回复
shadowlee 2000-11-28
- 打赏
- 举报
先用用DAO好啦!建立进行数据处理的时候,再去用ADO调用!
Public Sub create_db(dbname As String) 'bakname ------ 备份文件的路径及文件名
Dim aaa As String
Dim db As Database
Set db = DBEngine.Workspaces(0).CreateDatabase(dbname, dbLangGeneral)
Set db = Nothing
end sub
如果非要用ADO建立也可以,用MSADOX.DLL就行了,相关的资料在WINDOWS的PROGRAMFILES\COMMON下可以看到帮助文件!
Public Sub create_db(dbname As String) 'bakname ------ 备份文件的路径及文件名
Dim aaa As String
Dim db As Database
Set db = DBEngine.Workspaces(0).CreateDatabase(dbname, dbLangGeneral)
Set db = Nothing
end sub
如果非要用ADO建立也可以,用MSADOX.DLL就行了,相关的资料在WINDOWS的PROGRAMFILES\COMMON下可以看到帮助文件!
