error in accessing database

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

    error in accessing database

    guys,

    this is my first time to deploy website to the server, but every time i
    access the page this error always appears.

    ---------------------------------------------------------------------------------------------
    Server Error in '/sample' Application.
    --------------------------------------------------------------------------------

    The Microsoft Jet database engine cannot open the file
    '\\telsvr04\sam ple\App_Data\My Books.mdb'. It is already opened exclusively
    by another user, or you need permission to view its data.

    Description: An unhandled exception occurred during the execution of the
    current web request. Please review the stack trace for more information
    about the error and where it originated in the code.

    Exception Details: System.Data.Ole Db.OleDbExcepti on: The Microsoft Jet
    database engine cannot open the file
    '\\telsvr04\sam ple\App_Data\My Books.mdb'. It is already opened exclusively
    by another user, or you need permission to view its data.

    Source Error:


    An unhandled exception was generated during the execution of the
    current web request. Information regarding the origin and location of the
    exception can be identified using the exception stack trace below.


    ----------------------------------------------------------------------------------------------------------------

    the folder where all files are located is set to full control and everyone
    can access the file. i also tried to close the database to prevent the error
    "already open axclusively by another user" from appearing but the same error
    always appear in my browser.

    btw im using MS Access database.

    can you help me with this plssss....

    l30



    Tags: None
    • Cowboy \(Gregory A. Beamer\)
      #2
      Re: error in accessing database

      A couple of possibilities

      1. Someone (you?) has the file open
      2. The user (anonymous if you are not using windows auth) does not have
      access to the .mdb file
      3. Most likely: The user does not have write rights to the directory

      Access requires the creation of an .ldb file (lock file) when the database
      is accessed.

      --
      Gregory A. Beamer
      MVP; MCP: +I, SE, SD, DBA
      Stop Making Sense
      http://gregorybeamer.spaces.live.com
      Just another WordPress.com site


      *************** *************** *************** ****
      Think outside of the box!
      *************** *************** *************** ****
      "le0" <leo.tamisin@gm ail.comwrote in message
      news:OpnZCy26GH A.4116@TK2MSFTN GP03.phx.gbl...
      guys,
      >
      this is my first time to deploy website to the server, but every time i
      access the page this error always appears.
      >
      ---------------------------------------------------------------------------------------------
      Server Error in '/sample' Application.
      --------------------------------------------------------------------------------
      >
      The Microsoft Jet database engine cannot open the file
      '\\telsvr04\sam ple\App_Data\My Books.mdb'. It is already opened
      exclusively
      by another user, or you need permission to view its data.
      >
      Description: An unhandled exception occurred during the execution of the
      current web request. Please review the stack trace for more information
      about the error and where it originated in the code.
      >
      Exception Details: System.Data.Ole Db.OleDbExcepti on: The Microsoft Jet
      database engine cannot open the file
      '\\telsvr04\sam ple\App_Data\My Books.mdb'. It is already opened
      exclusively
      by another user, or you need permission to view its data.
      >
      Source Error:
      >
      >
      An unhandled exception was generated during the execution of the
      current web request. Information regarding the origin and location of the
      exception can be identified using the exception stack trace below.
      >
      >
      ----------------------------------------------------------------------------------------------------------------
      >
      the folder where all files are located is set to full control and everyone
      can access the file. i also tried to close the database to prevent the
      error "already open axclusively by another user" from appearing but the
      same error always appear in my browser.
      >
      btw im using MS Access database.
      >
      can you help me with this plssss....
      >
      l30
      >
      >
      >

        Comment

        • le0
          #3
          Re: error in accessing database

          Hi Greg,

          1. I close the db file to before accessing it remotely
          2. Im using my account that is authenticated by the server
          3. I also check the permission of the folder, everyone can access it with
          full control permission

          but the same error still appears, do i have to configure something in the
          server?

          l30

          "Cowboy (Gregory A. Beamer)" <NoSpamMgbworld @comcast.netNoS pamMwrote in
          message news:OPCCK656GH A.4276@TK2MSFTN GP04.phx.gbl...
          >A couple of possibilities
          >
          1. Someone (you?) has the file open
          2. The user (anonymous if you are not using windows auth) does not have
          access to the .mdb file
          3. Most likely: The user does not have write rights to the directory
          >
          Access requires the creation of an .ldb file (lock file) when the database
          is accessed.
          >
          --
          Gregory A. Beamer
          MVP; MCP: +I, SE, SD, DBA
          Stop Making Sense
          http://gregorybeamer.spaces.live.com
          Just another WordPress.com site

          >
          *************** *************** *************** ****
          Think outside of the box!
          *************** *************** *************** ****
          "le0" <leo.tamisin@gm ail.comwrote in message
          news:OpnZCy26GH A.4116@TK2MSFTN GP03.phx.gbl...
          >guys,
          >>
          >this is my first time to deploy website to the server, but every time i
          >access the page this error always appears.
          >>
          >---------------------------------------------------------------------------------------------
          >Server Error in '/sample' Application.
          >--------------------------------------------------------------------------------
          >>
          >The Microsoft Jet database engine cannot open the file
          >'\\telsvr04\sa mple\App_Data\M yBooks.mdb'. It is already opened
          >exclusively
          >by another user, or you need permission to view its data.
          >>
          >Description: An unhandled exception occurred during the execution of the
          >current web request. Please review the stack trace for more information
          >about the error and where it originated in the code.
          >>
          >Exception Details: System.Data.Ole Db.OleDbExcepti on: The Microsoft Jet
          >database engine cannot open the file
          >'\\telsvr04\sa mple\App_Data\M yBooks.mdb'. It is already opened
          >exclusively
          >by another user, or you need permission to view its data.
          >>
          >Source Error:
          >>
          >>
          > An unhandled exception was generated during the execution of the
          >current web request. Information regarding the origin and location of the
          >exception can be identified using the exception stack trace below.
          >>
          >>
          >----------------------------------------------------------------------------------------------------------------
          >>
          >the folder where all files are located is set to full control and
          >everyone
          >can access the file. i also tried to close the database to prevent the
          >error "already open axclusively by another user" from appearing but the
          >same error always appear in my browser.
          >>
          >btw im using MS Access database.
          >>
          >can you help me with this plssss....
          >>
          >l30
          >>
          >>
          >>
          >
          >

            Comment

            Previous template Next
            Working...