dcsimg
Results 1 to 2 of 2

Thread: VB5 app can't connect to a password-protected Access 97 database

  1. #1

    Thread Starter
    New Member
    Join Date
    Apr 2012
    Posts
    6

    VB5 app can't connect to a password-protected Access 97 database

    Hi all,

    Can someone please help me. I'm writing a VB5 app that connects to an Access 97 database using a data access control with the following parameters:

    Connect = "Access"
    DefaultType = 2 'UseODBC
    Exclusive = 0 'False
    Options = 0
    ReadOnly = 0 'False
    RecordsetType = 1 'Dynaset

    (The app sets the DatabaseName and RecordSource properties at runtime.)

    When the database doesn't have a password, it works perfectly. But when I give it a password ("OpenSesame") and change the Connect string to "Access;pwd=OpenSesame", I get this error:

    "Couldn't find installable ISAM."

    I need to solve this so that my database can be password-protected. Any ideas?

    I will also need to connect to the database from Crystal Reports, but first things first!
    Last edited by GregDenholm; Jul 4th, 2012 at 07:33 PM. Reason: I also needed to mention Crystal Reports

  2. #2

    Thread Starter
    New Member
    Join Date
    Apr 2012
    Posts
    6

    Re: VB5 app can't connect to a password-protected Access 97 database

    Hi people,

    No one has replied to my post. Just wondering if anyone has some ideas on how I can get my VB app to connect to a password-protected Access database. Please help, I'm desperate!

    Greg.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Featured


Click Here to Expand Forum to Full Width