使用 Data 控件打开 Accecc 数据库:
设置 Connect 属性为 ;pwd=密码
Data1.Connect = ";pwd=密码"
修改密码:
Data1.Database.NewPassword _老密码_, _新密码_
设置 Connect 属性为 ;pwd=密码
Data1.Connect = ";pwd=密码"
修改密码:
Data1.Database.NewPassword _老密码_, _新密码_
adoc.ConnectionString = "uid=admin;pwd=Password;driver={microsoft access driver (*.mdb)};dbq=c:\xj.mdb"
adoc.Open上例中的密码为"Password"
dim cn as new adodb.connection
cn.connectionstring="microsoft jet 3.51 ;persist security info=true;pwd=strpassword;uid=admin" & " data source=" & app.path & "\dbname.mdb"
cn.open
http://www.csdn.net/expert/topic/134/134226.xml
我对ADOX也很感兴趣
有谁能告诉我?
y1g1y1(袁飞☆曾经沧海难为水,除却VB不是云☆) -->ADOX Code?
你可以用独占 ADODB.Connection 执行 ALTER DATABASE PASSWORD 新密码 旧密码Dim adoConnection As New ADODB.Connection
adoConnection.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\NWind97WithPwd.mdb;Mode=Share Deny Read|Share Deny Write;Persist Security Info=False;Jet OLEDB:Database Password=1"
'ALTER DATABASE PASSWORD 新密码 旧密码
adoConnection.Execute "ALTER DATABASE PASSWORD NULL 1"
如何在用命令创建的ACEESS数据库中用命令加密码?
http://www.csdn.net/expert/topic/134/134226.xml
你是不是让出你的斑竹之位呢?:)
Private Sub Form_Load()
'引用msadox.dll
Dim cat As ADOX.Catalog
Set cat = New ADOX.Catalog
cat.Create "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\My.mdb;Jet OLEDB:Database Password=my"
Set cat = Nothing
End Sub
所以请教各位啊!
和
DataBase Password
是两个概念!
接着说...
Changes the password for a user account.