Ah Ha! I have narrowed it down

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • samadams_2006@yahoo.ca
    #1

    Ah Ha! I have narrowed it down

    I took off "friendly messaging" for the browser, and now have a more
    descriptive error for this problem. It says:

    The Microsoft Jet database engine cannot open the file
    'D:\databases\g uest.mdb'. It is already opened exclusively by another
    user, or you need permission to view its data.

    I have just rebooted the PC, so it cannot be opened exclusively by
    another user. When I define the Connection String in the
    OleConnection1, I have:

    Provider Tab
    ------------------
    a) Microsoft Jet 4.0 OLE DB Provider

    Connection Tab
    -----------------------
    a) I select the database "guestbook. mdb"
    b) User name: Admin
    c) I click on "Blank password", but not "Allow saving password"

    Advanced Tab
    --------------------
    a) I choose "Share Deny None"

    When the wizard is about to close I select: "Include Password"

    This didn't work, and I've played around with the settings, but to no
    avail. What's wrong?

    Thanks

    Tags: None
    • Göran Andersson
      #2
      Re: Ah Ha! I have narrowed it down

      Have you granted access to the database file for the user account that
      is running the code? The account is usually ASPNET or IIS_WPG.

      samadams_2006@y ahoo.ca wrote:
      I took off "friendly messaging" for the browser, and now have a more
      descriptive error for this problem. It says:
      >
      The Microsoft Jet database engine cannot open the file
      'D:\databases\g uest.mdb'. It is already opened exclusively by another
      user, or you need permission to view its data.
      >
      I have just rebooted the PC, so it cannot be opened exclusively by
      another user. When I define the Connection String in the
      OleConnection1, I have:
      >
      Provider Tab
      ------------------
      a) Microsoft Jet 4.0 OLE DB Provider
      >
      Connection Tab
      -----------------------
      a) I select the database "guestbook. mdb"
      b) User name: Admin
      c) I click on "Blank password", but not "Allow saving password"
      >
      Advanced Tab
      --------------------
      a) I choose "Share Deny None"
      >
      When the wizard is about to close I select: "Include Password"
      >
      This didn't work, and I've played around with the settings, but to no
      avail. What's wrong?
      >
      Thanks
      >

        Comment

        Previous template Next
        Working...