Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2003
    Location
    Australia
    Posts
    217

    Unhappy Unanswered: Connection String Problem

    I was trying to obtain the number of users who have logged into certain database which has security (has mdw file). I tried this with the OpenSchema method.

    * But I have problem with the Connection string:-
    cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\BlahBlah.mdb;User ID=developer;Password=hello;Persist Security Info=False"

    * I got this error message:-
    Cannot start your application. The workgroup information file is missing or opened exclusively by another user.

    Does anybody know what's wrong ? Thanks.

  2. #2
    Join Date
    Nov 2005
    Posts
    20
    Make sure that you have the correct path.

    Try this
    Code:
    "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\pathtodatabase.mdb;Jet OLEDB:System Database=\pathtofile.mdw;"
    Make sure that permissions have not been changed.
    Programming/Web Design
    http://eofficeprofessionals.com/forums

    Offer solutions-not criticism.

  3. #3
    Join Date
    Jul 2003
    Location
    Australia
    Posts
    217

    Smile thanks

    Yes, yes, yes, it works. You are fantastic.
    Thank you so much.

Posting Permissions

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