Re: Access File Password

From: jason (jason_at_no-replies.com)
Date: 10/09/03


Date: 8 Oct 2003 17:15:52 -0700

Richard,
You need to have a look at your connection string.
Make sure it includes..
  ConString := 'Provider=Microsoft.Jet.OLEDB.4.0;' +
                   'Data Source=' + databasePath +
                   ';Mode=Share Deny None;' +
                   'Persist Security Info=false;' +
                   'Jet OLEDB:Database Password=xxxxx';

Cheers,
Jason.

"Richard Gilbert" <r_a_g@bellsouth.net> wrote:
>I am trying to open a MS ACCESS ".MDB" database file with ADO and JET 4.0
>OLE DB Provider. I successfully open MDB files which do not have a password,
>but when I try to open a MDB file with a password, I get the following
>error:
>"Cannot start your application. The workgroup information file is missing
>or opened exclusively by another user."
>
>I copied the MDB file from another system, and I can open it in Access.
>What am I missing? Or what do I need to do?
>
>Thanks,
>Richard
>
>
>



Relevant Pages

  • Project 2000. Text Column
    ... Saved and closed project. ... Saved project as .mdb file and opened it in access. ... table is showing both the original (missing) text and the newly typed text. ...
    (microsoft.public.project)
  • Re: Open Connection fails with an "Unspecified Error"
    ... The example program below is only opening an closing a "devices.mdb" ... I'm probably missing something, but a MDB file is just a file. ...
    (microsoft.public.data.ado)
  • Access File Password
    ... OLE DB Provider. ... I successfully open MDB files which do not have a password, ... The workgroup information file is missing ... I copied the MDB file from another system, and I can open it in Access. ...
    (borland.public.delphi.database.ado)
  • Re: Access File Password
    ... My connection string was missing the 'Jet OLEDB:Database ' before Password. ... >>I copied the MDB file from another system, and I can open it in Access. ...
    (borland.public.delphi.database.ado)
  • Re: Open Connection fails with an "Unspecified Error"
    ... I'm probably missing something, but a MDB file is just a file. ... With multiple ... processes in a tight loop, IMHO, the only thing that would be "unexpected" ...
    (microsoft.public.data.ado)