We have a VB 6.0 application which opens an Access database using ODBC connections. We have included the dsn file and set up the connection in the code. Yet each time we open this *.mdb, it prompts the user for the userid and password. I was sure that there is a way to eliminate this. Can anybody help? Thanks.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How do you eliminate password prompt when opening Access DB/
- Thread starter purtman
- Start date
programmer4ever
Programmer
I can tell u that u can just remove the password from the MDB file -if it is not created with access 2000 or later
u just can edit the access file with any hex editor then goto to the latter near the first capital N latter change it to the binary value (131) â then save the mdb file to any name u want
and enjoy
the password just gone
becarfull that mean the password will be dameged so dont apply any password to the file
u just can edit the access file with any hex editor then goto to the latter near the first capital N latter change it to the binary value (131) â then save the mdb file to any name u want
and enjoy
the password just gone
becarfull that mean the password will be dameged so dont apply any password to the file
CajunCenturion
Programmer
You might also want to try adding the login id and password into the connection string.
"UID=<userid>;PWD=<password>;" Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein
"UID=<userid>;PWD=<password>;" Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein
- Status
Similar threads
- Locked
- Question
- Locked
- Question