7,763
社区成员
发帖
与我相关
我的任务
分享ADO 如何连接带密码的ACCESS数据库
sCnStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & sDbname & ";Persist Security Info=False;"
Set cn = New ADODB.Connection
cn.Open sCnStr
如何数据库有密码的话如何在连接串中表示
...全文
请发表友善的回复…
发表回复
Woodman007 2006-10-09
- 打赏
- 举报
sCnStr =
"Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Persist Security Info=False;" & _
"Data Source=MS Access Database;" & _
"Initial Catalog=" & sDbname & _
";pwd=你的密码"
"Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Persist Security Info=False;" & _
"Data Source=MS Access Database;" & _
"Initial Catalog=" & sDbname & _
";pwd=你的密码"
glc20022003 2006-10-09
- 打赏
- 举报
Const AppFileJtafAlm = "Y:\alarms.mdb;"
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & AppFileJtafAlm & "mode=read;" & _
"Jet OLEDB:DataBase password=www.rundeeco.com;"
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & AppFileJtafAlm & "mode=read;" & _
"Jet OLEDB:DataBase password=www.rundeeco.com;"
