Question

VB连接有密码的数据库怎么办?

StrConn = "PROVIDER=microsoft.jet.oledb.4.0;persist security info =false;data source=" & App.path & "\data.mdb"
Conn.Open StrConn

假如data.mdb设了密码,应该如何修改上面的语句??请高手指点!
StrConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.path & "\data.mdb;Persist Security Info=False;Jet OLEDB:DataBase Password=" & "1234"
为什么还是不行呀

Answer 1

StrConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\data.mdb;Persist Security Info=False;Jet OLEDB:DataBase Password=密码"

Answer 2

他那种肯定不行
myCon.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=日记mdb;Jet OLEDB:DataBase Password='qy is a stupid boy'"

Answer 3

DataConnectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + DataPath + ";Persist Security Info=False" + ";Jet OLEDB:Database Password=prowind"