How do you eliminate password prompt when opening Access DB/
How do you eliminate password prompt when opening Access DB/
(OP)
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.
RE: How do you eliminate password prompt when opening Access DB/
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
RE: How do you eliminate password prompt when opening Access DB/
"UID=<userid>;PWD=<password>;"
Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein