Secured Access database ado connection error


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 4 of 4

Thread: Secured Access database ado connection error

  1. #1
    Bob Sharp Guest

    Secured Access database ado connection error


    I'm trying to open a connection to a Microsoft Access (97) database that has
    a database password (set the password on database itself) - using the ado
    connection object. I receive the error ("Can't find installable ISAM").
    If I remove the password from the database and remove the user name & password
    from the connection string, everything works well. In other locations of
    the same program I am able to connect to the database, with password in place,
    using DAO. I was hoping to begin replacing some of the DAO objects with
    ADO, but need to determine what is going on first.

    Thanks for any help.

  2. #2
    Kevin MacCallum Guest

    Re: Secured Access database ado connection error


    If the database is just password protected you need to put the password in
    the "Jet OLEDBatabase Password" property of the connection string.

    If you are going to use Access security then you use the "User ID" & "Password"
    properties of the connection string plus you need to tell it where the MDW
    (Access security file) is through the "Jet OLEDB:System database" property.
    Here is an example of how to put the connection string together.

    sDBName = "C:\temp\maindb.mdb"
    sDBPwd = "Stuff1"
    sUserPwd = "PassItOverHere"
    sUserId = "User1"
    sMdw = "C:\temp\myapp.mdw"


    sConnstr = "Provider=Microsoft.Jet.OLEDB.4.0" & _
    ";Data Source=" & sDBName & _
    ";Mode=ReadWrite|Share Deny None" & _
    ";Persist Security Info=false" & _
    ";Jet OLEDBatabase Password=" & sDBPwd & _
    ";Password=" & sUserPwd & _
    ";User ID=" & sUserId & _
    ";Jet OLEDB:System database=" &sMdw

    Hope this helps

    Kevin

    "Bob Sharp" <robert.l.sharp@am.pnu.com> wrote:
    >
    >I'm trying to open a connection to a Microsoft Access (97) database that

    has
    >a database password (set the password on database itself) - using the ado
    >connection object. I receive the error ("Can't find installable ISAM").
    > If I remove the password from the database and remove the user name & password
    >from the connection string, everything works well. In other locations of
    >the same program I am able to connect to the database, with password in

    place,
    >using DAO. I was hoping to begin replacing some of the DAO objects with
    >ADO, but need to determine what is going on first.
    >
    >Thanks for any help.



  3. #3
    Douglas J. Steele Guest

    Re: Secured Access database ado connection error

    Just so you know, the database password on Access 97 databases offers
    little, if any, protection since it's so easy to crack.

    See http://www.trigeminal.com/lang/1033/...asp?ItemID=5#5 at MichKa's
    site for more details.

    --

    Doug Steele, Microsoft Access MVP
    Beer, Wine and Database Programming. What could be better?
    Visit "Doug Steele's Beer and Programming Emporium"
    http://I.Am/DougSteele/


    "Bob Sharp" <robert.l.sharp@am.pnu.com> wrote in message
    news:3a83f986$1@news.devx.com...
    >
    > I'm trying to open a connection to a Microsoft Access (97) database that

    has
    > a database password (set the password on database itself) - using the ado
    > connection object. I receive the error ("Can't find installable ISAM").
    > If I remove the password from the database and remove the user name &

    password
    > from the connection string, everything works well. In other locations of
    > the same program I am able to connect to the database, with password in

    place,
    > using DAO. I was hoping to begin replacing some of the DAO objects with
    > ADO, but need to determine what is going on first.
    >
    > Thanks for any help.




  4. #4
    Raju Guest

    Re: Secured Access database ado connection error


    In ADO record set the following code will accept in some mechine but not in
    all:-
    dim rs as recordset
    dim x as varient

    x = rs.bookmark
    rs.move 0, x

    Please advise me how to locate a perticular record.
    thanking you

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