VB and Access

I have an Access Database named: C:\TEST.MDB

I have set the password in Access 97 as: ABC

When I open the file TEST.MDB in Access it asks for the password after entering ABC I can access the information..
I want to open the Database file using a Visual Basic 5 Prof. Program, when I try opening the Database file VB always tells me I have used an incorrect PASSWORD!!!  

How do I open the Database File with the password???

LVL 1
jonderAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
DalinConnect With a Mentor Commented:
IF you are using a data control:
With Data1
DatabaseName=App.Path & "\my.mdb"
RecordSource="mytable"
Connect=";Pwd=" & pwd
Refresh
End With

If you are using DAO:
Set YourDB = DBEngine.WorkSpaces(0).OpenDatabase(YourDBFilewithPAth,False,False,";Pwd=" & pwd)

0
 
jonderAuthor Commented:
Edited text of question
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.