主题：asp打开有密码的ACCESS的三种方法

1。
Conn.open "Driver={Microsoft Access Driver (*.mdb)};" & _
                  "dbq=" & Server.MapPath("news.mdb") & ";pwd=twsnewspro"

2。
set conn = Server.CreateObject("ADODB.CONNECTION")
Provider = "Provider=Microsoft.Jet.OLEDB.4.0;"
DBPath = "Data Source=" & Server.MapPath("test.mdb")
Pwd = ";Jet OLEDB:Database Password=test"
conn.open Provider & DBPath & Pwd

3.
set conn=server.createobject("adodb.connection")  
  dbpath=server.MapPath("test.mdb")  
  conn.open   "driver={Microsoft Access Driver (*.mdb)};pwd=test;dbq="&DbPath

dim conn,sqlstr,DBPath
DBPath = Server.MapPath("list_data.mdb") 
Connstr = “DRIVER={Microsoft Access Driver (*.mdb)};DBQ=”& DBPath  
Set conn = Server.CreateObject("ADODB.Connection")
Conn.open Connstr