Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2006
    Location
    Washington, D.C
    Posts
    29

    Unanswered: Connection string not working

    I am having probelms logging into this database. I get an error that says:

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

    Code:
    Dim connStr As String
       Set MyConn = New ADODB.Connection
       
       connStr = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
                 "Data Source = M:\REGIONS\Privacy\Hipaa Privacy Phone List2.mdb"
       MyConn.CursorLocation = adUseClient
       MyConn.open connStr, "UserName"

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    You need to specify the Admin account and blank password when accessing Access like this. Even without any apparent security, Access (behind the scenes) is actualy acessing your data with the admin account. When connecting you need to sepcify this explicitly.
    Testimonial:
    pootle flump
    ur codings are working excelent.

Posting Permissions

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