Re: Password problem

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Paul Clement (UseAdddressAtEndofMessage_at_swspectrum.com)
Date: 10/04/04

  • Next message: Tim Baur: "Re: sql query" 
    Date: Mon, 04 Oct 2004 12:44:47 -0500

    On Mon, 4 Oct 2004 09:21:25 -0400, "David" <not@directemail.com> wrote:

    ¤ Hey,
    ¤
    ¤ I've been using ADO for a few years now and now I need to simply open
    ¤ an access DB using DAO3.6 which has is password protected.
    ¤
    ¤ set dbtemp = opendatabase("MyDB.MDB",False,False," ;pwd=mypass")
    ¤
    ¤ I get an error about "cannot find...ISAM" something, something...
    ¤ If I remove the second False I get "Invalid password"
    ¤
    ¤ I don't want to work with workspaces nor ODBC I simply want to open the
    ¤ password protected Access2000 DB using DAO3.6.
    ¤

    I believe you need to specify the driver in the Connect string parameter

    set dbtemp = opendatabase("MyDB.MDB",False,False,"MS Access;pwd=mypass")

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

  • Next message: Tim Baur: "Re: sql query"

    Relevant Pages

    • Re: connect string for Access 2000
      ... I need the connect string for getting to an Access 2000 mdb using ADO from VB6. ... Microsoft MVP ...
      (microsoft.public.vb.enterprise)
    • Re: Hooking into Microsoft Access
      ... Hey all, ... Is there a way to access all the reports that have been created for an MS Access application and list them in a datagrid? ... Microsoft MVP ...
      (microsoft.public.dotnet.general)
    • lots of electrical optimistic heats will loosely punish the speechs
      ... Taysseer when the missing newspapers dismiss at first the honest ... Hardly any varied liquid market copes expenses in part Johann's ... Hey, delights list till tremendous lochs, unless they're ... As yesterday as Paul inspects, you can twist the dilemma much more ...
      (sci.crypt)
    • Re: Brand Spankin Newbie ADO.NET Question
      ... This posting is provided "AS IS" with no warranties, and confers no rights. ... > examples in my Apress book "ADO.NET and ADO Examples and Best Practices" ... > Microsoft MVP ... > Please reply only to the newsgroup so that others can benefit. ...
      (microsoft.public.vb.database.ado)
    • Re: How to Mimic Access Externally Linked Tables using ADO?
      ... William (Bill) Vaughn ... > we could transfer, as Access does, in a query through ADO, things would go ... >> It's the query engine that does all the database IO, ... >> Microsoft MVP ...
      (microsoft.public.data.ado)