Using an encrypted MDB

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Anil Gupte
    #1

    Using an encrypted MDB

    I am using an MDB file which I have secured using the Access 2000 security
    wizard. When I try to open it using a VB program I get an exception saying
    "Cannot start your application. The wrokgroup information file is missing or
    opened exclusively by another user". However, I can open it manually by
    double-clicking on it and using the userid and password. I am using this
    string to open it.

    ConnStrMDB = "Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry
    Path=;User Id=" & strUID & ";Password= " & strPWD & ";" & _
    "Jet OLEDB:Database Locking Mode=1;Data Source=" & MDBFile & ";Jet
    OLEDB:Engine " & _
    "Type=5;Provide r=Microsoft.Jet .OLEDB.4.0;Jet OLEDB:System database=;Jet
    OLEDB:SFP=False ;persist security " & _
    "info=True;Exte nded Properties=;Mod e=Share Deny None;Jet OLEDB:Encrypt
    Database=False; Jet OLEDB:Create System " & _
    "Database=False ;Jet OLEDB:Don't Copy Locale on Compact=False;J et
    OLEDB:Compact Without Replica Repair=False;" & _
    "User ID=Admin;Jet OLEDB:Global Bulk Transactions=1"
    ConnWizoMDB = New OleDbConnection (ConnStrMDB)
    ConnWizoMDB.Ope n()

    What am I doing wrong?

    TIA,
    --
    Anil Gupte
    Home - k.e.e.n. inc.
    https://www.keeninc.net
    Innovate with UsLeading the Way in Advanced Technology Solutions Discover state-of-the-art services in logistics, databases, and AI designed for evolving

    www.icinema.com


    Tags: None
    • Michel Posseth [MCP]
      #2
      Re: Using an encrypted MDB

      if you crerated a new workgroup information file ( that is the only true
      secure way of a password protected encrypted access database )

      your connection string should be like this

      Provider=Micros oft.Jet.OLEDB.4 .0;Data Source=pathtodb \mydb.mdb;Jet
      OLEDB:System Database=pathto modified\YourSy stem.mdw;User
      ID=myUsername;P assword=myPassw ord;

      HTH

      Michel



      "Anil Gupte" <anil-list@icinema.co mschreef in bericht
      news:u7xMO4FTIH A.1212@TK2MSFTN GP05.phx.gbl...
      >I am using an MDB file which I have secured using the Access 2000 security
      >wizard. When I try to open it using a VB program I get an exception saying
      >"Cannot start your application. The wrokgroup information file is missing
      >or opened exclusively by another user". However, I can open it manually by
      >double-clicking on it and using the userid and password. I am using this
      >string to open it.
      >
      ConnStrMDB = "Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry
      Path=;User Id=" & strUID & ";Password= " & strPWD & ";" & _
      "Jet OLEDB:Database Locking Mode=1;Data Source=" & MDBFile & ";Jet
      OLEDB:Engine " & _
      "Type=5;Provide r=Microsoft.Jet .OLEDB.4.0;Jet OLEDB:System database=;Jet
      OLEDB:SFP=False ;persist security " & _
      "info=True;Exte nded Properties=;Mod e=Share Deny None;Jet OLEDB:Encrypt
      Database=False; Jet OLEDB:Create System " & _
      "Database=False ;Jet OLEDB:Don't Copy Locale on Compact=False;J et
      OLEDB:Compact Without Replica Repair=False;" & _
      "User ID=Admin;Jet OLEDB:Global Bulk Transactions=1"
      ConnWizoMDB = New OleDbConnection (ConnStrMDB)
      ConnWizoMDB.Ope n()
      >
      What am I doing wrong?
      >
      TIA,
      --
      Anil Gupte
      Home - k.e.e.n. inc.
      https://www.keeninc.net
      Innovate with UsLeading the Way in Advanced Technology Solutions Discover state-of-the-art services in logistics, databases, and AI designed for evolving

      www.icinema.com
      >

        Comment

        • Pavanaja U B
          #3
          Re: Using an encrypted MDB

          Are you using non-ENglish locale by any chance. In that case Jet engine does
          not work. It is a known issue. I had this problem earlier. I had set kannada
          as my language/locale. Jet engine was failing. When I set it back to English
          it worked. It took nearly three months for me to figure out his bug.

          -Pavanaja

          "Anil Gupte" <anil-list@icinema.co mwrote in message
          news:u7xMO4FTIH A.1212@TK2MSFTN GP05.phx.gbl...
          >I am using an MDB file which I have secured using the Access 2000 security
          >wizard. When I try to open it using a VB program I get an exception saying
          >"Cannot start your application. The wrokgroup information file is missing
          >or opened exclusively by another user". However, I can open it manually by
          >double-clicking on it and using the userid and password. I am using this
          >string to open it.
          >
          ConnStrMDB = "Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry
          Path=;User Id=" & strUID & ";Password= " & strPWD & ";" & _
          "Jet OLEDB:Database Locking Mode=1;Data Source=" & MDBFile & ";Jet
          OLEDB:Engine " & _
          "Type=5;Provide r=Microsoft.Jet .OLEDB.4.0;Jet OLEDB:System database=;Jet
          OLEDB:SFP=False ;persist security " & _
          "info=True;Exte nded Properties=;Mod e=Share Deny None;Jet OLEDB:Encrypt
          Database=False; Jet OLEDB:Create System " & _
          "Database=False ;Jet OLEDB:Don't Copy Locale on Compact=False;J et
          OLEDB:Compact Without Replica Repair=False;" & _
          "User ID=Admin;Jet OLEDB:Global Bulk Transactions=1"
          ConnWizoMDB = New OleDbConnection (ConnStrMDB)
          ConnWizoMDB.Ope n()
          >
          What am I doing wrong?
          >
          TIA,
          --
          Anil Gupte
          Home - k.e.e.n. inc.
          https://www.keeninc.net
          Innovate with UsLeading the Way in Advanced Technology Solutions Discover state-of-the-art services in logistics, databases, and AI designed for evolving

          www.icinema.com
          >

            Comment

            • Anil Gupte
              #4
              Re: Using an encrypted MDB

              Thanx, that works great!

              --
              Anil Gupte
              Home - k.e.e.n. inc.
              https://www.keeninc.net
              Innovate with UsLeading the Way in Advanced Technology Solutions Discover state-of-the-art services in logistics, databases, and AI designed for evolving

              www.icinema.com

              "Michel Posseth [MCP]" <msnews@posseth .comwrote in message
              news:%235CtyEJT IHA.5404@TK2MSF TNGP03.phx.gbl. ..
              if you crerated a new workgroup information file ( that is the only true
              secure way of a password protected encrypted access database )
              >
              your connection string should be like this
              >
              Provider=Micros oft.Jet.OLEDB.4 .0;Data Source=pathtodb \mydb.mdb;Jet
              OLEDB:System Database=pathto modified\YourSy stem.mdw;User
              ID=myUsername;P assword=myPassw ord;
              >
              HTH
              >
              Michel
              >
              >
              >
              "Anil Gupte" <anil-list@icinema.co mschreef in bericht
              news:u7xMO4FTIH A.1212@TK2MSFTN GP05.phx.gbl...
              >>I am using an MDB file which I have secured using the Access 2000 security
              >>wizard. When I try to open it using a VB program I get an exception
              >>saying "Cannot start your application. The wrokgroup information file is
              >>missing or opened exclusively by another user". However, I can open it
              >>manually by double-clicking on it and using the userid and password. I am
              >>using this string to open it.
              >>
              >ConnStrMDB = "Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry
              >Path=;User Id=" & strUID & ";Password= " & strPWD & ";" & _
              >"Jet OLEDB:Database Locking Mode=1;Data Source=" & MDBFile & ";Jet
              >OLEDB:Engine " & _
              >"Type=5;Provid er=Microsoft.Je t.OLEDB.4.0;Jet OLEDB:System database=;Jet
              >OLEDB:SFP=Fals e;persist security " & _
              >"info=True;Ext ended Properties=;Mod e=Share Deny None;Jet OLEDB:Encrypt
              >Database=False ;Jet OLEDB:Create System " & _
              >"Database=Fals e;Jet OLEDB:Don't Copy Locale on Compact=False;J et
              >OLEDB:Compac t Without Replica Repair=False;" & _
              >"User ID=Admin;Jet OLEDB:Global Bulk Transactions=1"
              >ConnWizoMDB = New OleDbConnection (ConnStrMDB)
              >ConnWizoMDB.Op en()
              >>
              >What am I doing wrong?
              >>
              >TIA,
              >--
              >Anil Gupte
              >www.keeninc.net
              >www.icinema.com
              >>
              >
              >

                Comment

                Previous template Next
                Working...