有答案了。这样; 用DAO3.6 肯定不行, 回到参照里面, 引用office12 access . 用法和 DAO一样 Dim s As String s = "D:\db" Dim MYWS As Workspace Dim MYDB As Database DBEngine.DefaultType = dbUseJet Set MYWS = DBEngine.Workspaces(0) Set MYDB = MYWS.OpenDatabase(s & "\temp", True, False) MsgBox "ok" End
学VC编写数据库程序,需要一定基础,最好先学好ATL。
使用DAO3.6 打开一个access2007格式(accdb)的数据库,但是程序提示打不开这种格式。mdb格式的可以。调查老半天。 客户还非要access2007
用DAO3.6 肯定不行, 回到参照里面, 引用office12 access .
用法和 DAO一样
Dim s As String
s = "D:\db"
Dim MYWS As Workspace
Dim MYDB As Database
DBEngine.DefaultType = dbUseJet
Set MYWS = DBEngine.Workspaces(0)
Set MYDB = MYWS.OpenDatabase(s & "\temp", True, False)
MsgBox "ok"
End