Dim con As ADODB.Connection con.Open "Provider=Microsoft.Jet.OLEDB.4.0;Password=111;Data Source=" & App.path & "\alertData.thl"
再说了,我用的是 Public RS As Recordset, WS As Workspace,MyDB As Database Set WS = DBEngine.Workspaces(0) '打开数据库 Set MyDB = WS.OpenDatabase(App.Path & "\alertData.thl", 1, 1) 啊,这种打开方法怎么添加密码呢?
这种方法我没用过,你试试把你的 Set WS = DBEngine.Workspaces(0) '打开数据库 改成下面的 Set WS = DBEngine.CreateWorkspace("", "Admin", "111")
con.Open "Provider=Microsoft.Jet.OLEDB.4.0;Password=111;Data Source=" & App.path & "\alertData.thl"
Public RS As Recordset, WS As Workspace,MyDB As Database
Set WS = DBEngine.Workspaces(0) '打开数据库
Set MyDB = WS.OpenDatabase(App.Path & "\alertData.thl", 1, 1)
啊,这种打开方法怎么添加密码呢?
Set WS = DBEngine.Workspaces(0) '打开数据库
改成下面的
Set WS = DBEngine.CreateWorkspace("", "Admin", "111")