a) Do not piggy-back onto another thread without changing the subject
b) Please delete all the extraneous stuff that is not relevant to your
question

c) Please look at this site:
http://www.able-consulting.com/ado_conn.htm#ODBCDriverForAccess

(OR)
d) Specify the username/password in the DSN rather than in the connection
string

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
: Hi Ken,
: I also got a problem with DSN to access a MSACCESS mdb with password,
: when i set
: Session("connectstring")="DSN=INTERNALCOSTING;UID=ADMIN;PWD=PASSWD"
:
: It gives me error saying that "invalid password".
: Actually My password is not user level it is database level.
: When i use dsn less string i get connected easily.
:
: cst="Provider=Microsoft.Jet.OLEDB.4.0;Data
: Source=c:/sample/tryit/tryit_local/database/projectcosting.mdb"
: cst=cst & ";Persist Security Info=False;Jet OLEDB:Database
: Password=passwd"
: Session("ConnectString") = cst
: it works in this case, but how can i give database level password WITH DSN
:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~