reading .mdb file with VB6

How can I read a .mdb file with VB6. All permissions are set to default except the password. I can read it fine if I remove the password, but as soon as I add a password, My VB app can't access it anymore. Any ideas??
LVL 23
Who is Participating?
wdavidsmithConnect With a Mentor Commented:
For users to gain access to the secured objects in your database, DAO must have the location of this workgroup information file. The location can be identified to DAO either by specifying it in the Windows Registry or by setting the SystemDB property.

DBEngine.SystemDB = "c:\windows\system\system.mdw"

Dim dbsTheDatabase As Database
Set dbsTheDatabase = OpenDatabase("c:\folder\database.mdb")

For this option to have any effect, you must set the SystemDB property before your application initializes the DBEngine object (that is, before creating an instance of any other DAO object). The scope of this setting is limited to your application and can't be changed without restarting your application.

ahammarAuthor Commented:
Edited text of question
If you refer at user password you can set the default user and default password for opening workspace (see more on SystemDB property in help or Books online). If you refer at database password, I'm sorry but once I digged for that with no success.
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.