How do you eliminate password prompt when opening Access DB/

Question

How do you eliminate password prompt when opening Access DB/

purtman (Programmer)

(OP)

11 Mar 02 09:32

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.

programmer4ever (Programmer) · Answer 1 · 2002-06-01 10:44:48

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

CajunCenturion (Programmer) · Answer 2 · 2002-06-03 09:05:04

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

Come Join Us!

Posting Guidelines

How do you eliminate password prompt when opening Access DB/