VB4 to Access DB security

I am using a vb4 data control to open a .mdb file that has a database password set (not user level).  I get an 'invalid password' error in trying to access the database.  how do i inform the db of the password using the data control.  If there is no way to do it with the data control, is there a way to do it DAO.  thank you in advance.
svfafelAsked:
Who is Participating?
 
DalinConnect With a Mentor Commented:
svfafel
Try this: Let me know if any problem

With Data1
DatabaseName=App.Path & "\my.mdb"
RecordSource="mytable"
Connect=";Pwd=" & pwd
Refresh
End With

Regards
Dalin
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.