Results 1 to 2 of 2

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

Threaded View

  1. Jul 3rd, 2012, 08:38 PM #1
    GregDenholm
    GregDenholm is offline

    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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
  •  

Forum Rules


Click Here to Expand Forum to Full Width