如何打开加密的数据库ACCESS

[chuting1]

请教一个问题
以前我们公司用的系统中数据库为ACCESS,没有加密
,以前我是这样写的
dim mydb as database
dim myrs as recordset
set mydb=workspaces(0).opendatabase(sys\&"aaa.mdb")
set myrs=mydb.openrecordset("",)
....

现在数据库加密了，请问还要加什么参数
才能打开它

[Richard2001]

用ADO吧：
Dim cn As New ADODB.Connection
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;PERSIST SECURITY INFO=TRUE;Data Source=" & App.Path & "\db.mdb" , "管理员", "1111"

[yefm]

'用Dao
Dim mywork As Workspace
Dim mydb As Database

Set mywork = DBEngine.Workspaces(0)
Set mydb = mywork.OpenDatabase("C:\db1.mdb", False, False, ";pwd=abc") '以共享、读写方式打开

[chuting1]

谢谢,我先试试再联系

[yefm]

'用Dao
Dim mywork As Workspace
Dim mydb As Database

Set mywork = DBEngine.Workspaces(0)
Set mydb = mywork.OpenDatabase("c:\db1.mdb", False, False, ";pwd=abc") '以共享、读写方式打开,密码:abc

[ganzhiruogy]

用ADO：
Dim TAdoCn As New Connection
TAdoCn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Jet OLEDB:Database Password=1234;Data Source="c:\a.mdb"

[tony_jian]

DAO方法:
Dim db1 As Database
Set db1 = mywork.OpenDatabase("库的路径", False,False, ";pwd=123")

ADO方法：
Dim Cn As New Connection
Cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Jet OLEDB:Database Password=1234;Data Source="库的路径"

[shawls]

火山说全了

[chuting1]

谢谢你们了待会儿给分