• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 169
  • Last Modified:

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.
0
svfafel
Asked:
svfafel
1 Solution
 
DalinCommented:
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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now