how to access password protected database?


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 7 of 7

Thread: how to access password protected database?

  1. #1
    Sean Guest

    how to access password protected database?


    Hi experts,

    I have a quick question for you.

    I have a program, written in VB6, that uses a Data object to access a Microsoft
    Access database. The database has recently had a password put onto it.
    Now, instead of just access the database though the Data object, I need to
    input this password so that the program can use the database. But, I'm not
    100% sure on the how.

    I'd appreciate any help in this matter.

    Sean

  2. #2
    Michael Culley Guest

    Re: how to access password protected database?

    Just put Password=MyPassword in the connection string.

    --
    Michael Culley
    www.vbdotcom.com



  3. #3
    Paul Clement Guest

    Re: how to access password protected database?

    On 17 Jul 2002 17:40:26 -0700, "Sean" <win2k2b@aol.com> wrote:


    Hi experts,

    I have a quick question for you.

    I have a program, written in VB6, that uses a Data object to access a Microsoft
    Access database. The database has recently had a password put onto it.
    Now, instead of just access the database though the Data object, I need to
    input this password so that the program can use the database. But, I'm not
    100% sure on the how.

    I'd appreciate any help in this matter.


    I don't know whether you are using ADO, DAO or one of the DataControls but the following refers to
    ADO:

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


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

  4. #4
    Sean Guest

    Re: how to access password protected database?


    >I don't know whether you are using ADO, DAO or one of the DataControls but

    the following
    >refers to
    >ADO:
    >
    >http://support.microsoft.com/default...;EN-US;q191754
    >
    >
    >Paul ~~~ pclement@ameritech.net
    >Microsoft MVP (Visual Basic)


    Ah, thank you very much, that did the trick.
    Sean

  5. #5
    ralph Guest

    Re: how to access password protected database?


    "Michael Culley" <mculley@optushome.com.au> wrote:
    >Just put Password=MyPassword in the connection string.
    >
    >--
    >Michael Culley
    >www.vbdotcom.com
    >
    >


    In the same vein, is there any cute work-arounds for handling "pass-thru"
    or linked tables from another database (as400, oracle). That is without skipping
    access and opening the table with a separate connection.

  6. #6
    Ronny Guest

    Re: how to access password protected database?


    i know how to put password=mypassword, (using ado)

    but if the case is, i used adodc ? how ????

    "ralph" <nt_consulting32@hotmail.com> wrote:
    >
    >"Michael Culley" <mculley@optushome.com.au> wrote:
    >>Just put Password=MyPassword in the connection string.
    >>
    >>--
    >>Michael Culley
    >>www.vbdotcom.com
    >>
    >>

    >
    >In the same vein, is there any cute work-arounds for handling "pass-thru"
    >or linked tables from another database (as400, oracle). That is without

    skipping
    >access and opening the table with a separate connection.



  7. #7
    Michael Culley Guest

    Re: how to access password protected database?

    The adodc has a connection string, just add it to that.

    --
    Michael Culley
    www.vbdotcom.com


    "Ronny" <ronnyweb2000@yahoo.com> wrote in message
    news:3d3d0616$1@10.1.10.29...
    >
    > i know how to put password=mypassword, (using ado)
    >
    > but if the case is, i used adodc ? how ????
    >
    > "ralph" <nt_consulting32@hotmail.com> wrote:
    > >
    > >"Michael Culley" <mculley@optushome.com.au> wrote:
    > >>Just put Password=MyPassword in the connection string.
    > >>
    > >>--
    > >>Michael Culley
    > >>www.vbdotcom.com
    > >>
    > >>

    > >
    > >In the same vein, is there any cute work-arounds for handling "pass-thru"
    > >or linked tables from another database (as400, oracle). That is without

    > skipping
    > >access and opening the table with a separate connection.

    >




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