Results 1 to 3 of 3

Thread: What is connection string for opening password protected Access 2K file thru VB.NET?

  1. Jul 2nd, 2004, 11:00 AM #1
    sbasak
    sbasak is offline

    Thread Starter
    Fanatic Member sbasak's Avatar
    Join Date
    Aug 2001
    Location
    Globe Trotter
    Posts
    524

    Unhappy What is connection string for opening password protected Access 2K file thru VB.NET?

    I used following string

    "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=library.mdb;Password=librarian;User ID=librarian;"

    But while trying to open the file thru VB.NET, I get following error.

    Workgroup information file is missing or opened exclusively by another user.

    Access file without password is opening fine.

    Any help?

    Thanx a lot!
    Life is a one way journey, not a destination. Travel it with a smile and never regret anything.
    Yesterday is history, tomorrow is a mystery, today is gift - that's why we call it present.
    Reply With Quote Reply With Quote
  2. Jul 2nd, 2004, 11:37 AM #2
    MrGTI
    MrGTI is offline
    Frenzied Member MrGTI's Avatar
    Join Date
    Oct 2000
    Location
    Ontario, Canada
    Posts
    1,277

    Question

    Try: User ID=Admin
    ~Peter

    Reply With Quote Reply With Quote
  3. Jul 5th, 2004, 08:16 AM #3
    sbasak
    sbasak is offline

    Thread Starter
    Fanatic Member sbasak's Avatar
    Join Date
    Aug 2001
    Location
    Globe Trotter
    Posts
    524
    It would be this

    Jet OLEDBatabase Password=MyDbPassword
    User Id is Admin correct
    Life is a one way journey, not a destination. Travel it with a smile and never regret anything.
    Yesterday is history, tomorrow is a mystery, today is gift - that's why we call it present.
    Reply With Quote Reply With Quote
« Previous Thread | Next 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