?
Solved

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

Posted on 2002-03-23
2
Medium Priority
?
154 Views
Last Modified: 2010-05-02
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 ..

0
Comment
Question by:arna
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 70

Accepted Solution

by:
Éric Moreau earned 300 total points
ID: 6891289
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 6891549
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

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Have you ever wanted to restrict the users input in a textbox to numbers, and while doing that make sure that they can't 'cheat' by pasting in non-numeric text? Of course you can do that with code you write yourself but it's tedious and error-prone …
I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Suggested Courses

801 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question