带密码的数据库如何连接呀

[liushiying]

带密码的数据库如何连接呀
conn.ConnectionString = "Provider = Microsoft.Jet.OLEDB.4.0; " & _
"Data Source = " & Application.StartupPath & "\now.mdb "

[renyu732]

Standard security:

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;User Id=admin;Password=;"



Workgroup (system database):

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;Jet OLEDB:System Database=system.mdw;"



With password:

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;Jet OLEDB:Database Password=MyDbPassword;"

[li_guang_hua]

Password=???????

[HGSWK]

设置了access数据库密码(如123)后的连接字符串：
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\My Documents\swk\Northwind\Northwind.mdb;Jet OLEDB:Database Password=123"

[chengpei_chen]

这样的问题在网上随便艘一下就能找到
楼上这么多应该能够解决了吧

[泡沫游走]

Public Shared str As String = "Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:database password=密码;;Data Source=f:\CQdata.mdb"

[chengpei_chen]

http://www.connectionstrings.com
这是一个数据库连接的网站,上面有各种数据库的连接代码

[yinweihong]

Private mdbPath As String = "C:\adotest\test.mdb"
Dim pwd As String = "12"
Public strCn As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & mdbPath & ";" & _
"Jet OLEDB:Database Password=" & pwd & ";"
此串在有密和无密情况下均能接上

[ou108]

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<appSettings>
<add key="ServerName" value="localhost"/>
<add key="Database" value="jokevin"/>
<add key="UserID" value="sa"/>
<add key="PassWord" value="0114"/>
</appSettings>
</configuration>
把<add key="ServerName" value="localhost"/>
<add key="Database" value="jokevin"/>
<add key="UserID" value="sa"/>
<add key="PassWord" value="0114"/>
这里改一下就OK了