I have a database in MS Access which is password Protected and I wish access it

I am using VB 6.0 and Access . Now the Database in Access is Password Protected and MS Access has Logon Name Admin
Password :- Password  (i.e this is to start MS Access)
Below is the code to logon to MS Access but I don't Know how to open the Password Protected Database .

Set conn = New Connection
            Dim path As String
            path = App.path & "\Expo2002.mdb"
            Set res = New Recordset
            Set comm = New Command
            Dim str As String    '//This is the connection string

 str = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
                    "Password=password;User ID=Admin;" & _
                     "Data Source= " & path & ";" & _
                     "Persist Security Info = True;" & _
 "Jet OLEDB:System database=C:\Windows\System\system.mdw"
               
           
            With conn
                    .CursorLocation = adUseClient
                    .Open str
                   
            End With
           
            comm.ActiveConnection = conn
           
           
            Exit Sub


Please treat this matter the most Urgent ..

arnaAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Éric MoreauConnect With a Mentor Senior .Net ConsultantCommented:
0
 
mlmccCommented:
Which version of Access

There are many questions on this web site with an answer
Access 2000
http://www.experts-exchange.com/crystal/Q.20273716.html


http://www.experts-exchange.com/jsp/qShow.jsp?
ta=visualbasic&qid=20268832

http://www.experts-exchange.com/jsp/qShow.jsp?ta=visualbasic&qid=20246084

good luck
mlmcc
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.