DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 4 of 4

Thread: ADO - Open Access with password

  1. #1
    Alex Guest

    ADO - Open Access with password


    How can i Open an Access with password?

    Thank You!!

  2. #2
    Steve Guest

    Re: ADO - Open Access with password


    "Alex" <alex@ssys.com.ar> wrote:
    >
    >How can i Open an Access with password?
    >
    >Thank You!!


    Well, depends on which password you need to provide. There is a Database
    Password, and your general user login passwords.

    To provide a database password:

    before you open your connection, place a line that looks like:

    moConnection.Properties("Jet OLEDBatabase Password") = "<Password String>"
    Where <Password String> is your database password.

    To provide user login information, use...
    moConnection.Properties("Jet OLEDB:System Database") = "<Path to System.MDW
    file>"
    followed by in your Open statement:
    Call moConnection.Open(, "<User ID>", "<Password>")

    Where <User ID> and <Password> are the user ID and password to have the application
    log in as.

    The statements can also be added as part of the command line text, and it
    is required that way with ADO.NET. (I just find it gets the command string
    a bit messy

    Steve.

  3. #3
    Guest

    Re: ADO - Open Access with password


    tools->security...
    set the password

  4. #4
    Paul Clement Guest

    Re: ADO - Open Access with password

    On 9 Jul 2002 20:05:33 -0700, "Alex" <alex@ssys.com.ar> wrote:


    How can i Open an Access with password?


    You don't indicate whether you are using Jet security or just a simple database password, but if you
    don't see the answer in Steve's post, try here:

    http://support.microsoft.com/default...;EN-US;q191754


    Paul ~~~ pclement@ameritech.net
    Microsoft MVP (Visual Basic)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center