Results 1 to 4 of 4

Thread: Access db connection error.

Threaded View

  1. #1

    Thread Starter
    Hyperactive Member
    Join Date
    Aug 2004
    Location
    Bloomingdale, IL USA
    Posts
    284

    Access db connection error.

    I am using VB 6.0 with an Access database. The program worked fine until I password protected the database. Now I am getting the following error:

    "Cannot start your application. The workgroup information file is missing or opened exclusively by another user."

    The path is correct and I did open the database exclusively to set the password, but then closed it. The following is the connection string I am using. I can get it to work with an ODBC connection, but I don't want to use that.

    VB Code:
    1. Set Conn = New Connection
    2.  
    3. Conn.ConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data source=" + App.Path + "\database.mdb;password=pword"
    4. 'The following one works
    5. 'Conn.ConnectionString = "PROVIDER=MSDASQL;Data Source=Support;password=pword"
    6.  
    7. Conn.open

    Please help!
    Last edited by Chrissy; Mar 2nd, 2006 at 05:23 PM. Reason: add something

Posting Permissions

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



Click Here to Expand Forum to Full Width