如何打开一个带密码的ACCESS数据库？
我写了下面的代码：
set conn=server.createobject( "adodb.connection ")
conn.open "driver={microsoft access driver (*.mdb)};psw=a98229e0;dbq= "&server.mappath( "users.mdb ")
exec= "select user from user_base "
set rs=server.createobject( "adodb.recordset ")
rs.open exec,conn,1,1
'循环遍历记录
Find = 0
do while not rs.eof
UserName = rs( "user ")
If UserName = Users Then
Find = 1
Exit Do
End If
rs.movenext
loop
'关闭数据库
rs.close
set rs=nothing
conn.close
set conn=nothing
第二句打开的时候密码设置了，但总有错误，请问应该怎么改？
[解决办法]
conn.open "driver={microsoft access driver (*.mdb)};psw=a98229e0;dbq= "&server.mappath( "users.mdb ") , ' ', '密码 '
[解决办法]
dim rs
rs.open "driver={microsoft access driver (*.mdb)};psw=a98229e0;dbq= "&server.mappath( "users.mdb ") , ' ', 'a98229e0 '
[解决办法]
同意楼上的
[解决办法]
dim conn
dim dbpath
set conn=server.createobject( "adodb.connection ")
DBPath = Server.MapPath( "db/db.mdb ")
conn.Open "driver={Microsoft Access Driver (*.mdb)};uid=;pwd=sz168sz168sz168pj41;dbq= " & DBPath
conn.CursorLocation = adUseClient
[解决办法]
顶
