How to connect vb6 into a password protected .mdb?

[xtianenikkian]

Good day,

I have a system and it has a studentdatabase.mdb database, ive putted password into the .mdb file and now when I run the .exe file of my vb6 program it says
Not a valid password,

Question: How can I automatically put the password of the .mdb file when i clicked or start the vb6 program .exe? so my vb6 program can automatically access the database ".mdb file"?

[Jx_Man]

see this thread

[AndreRet]

Depends whether you are using a data control (see the link in JX's post) or code. You need to supply the password in the connection string as well as the username to successfully log in to the access database.

[Edit]If I had looked further at the other posts I would have seen that it contains the answer, my bad.:)[Edit]