如何用代码打开加了密码的Acess数据库??

Question

set con=server.createobject("adodb.connection")
constr="dbq="+server.mappath("test1.mdb")+";driver={microsoft access driver (*.mdb)}, uid=USERID, pwd=PASSWORD"
conn.open constr

Answer 1

set conn=server.createobject("adodb.connection")
constr="dbq="+server.mappath("test1.mdb")+";driver={microsoft access driver (*.mdb)}, uid=USERID, pwd=PASSWORD"
conn.open constr

Answer 2

仅仅是连接字符串变了"provider=microsoft.jet.oledb.4.0;data source="&server.mappath("data.mdb")&"User Id=用户名;Password=密码;"