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@xxxxxxxxxxxxxxxxxx> wrote in
message news:OPCCK656GHA.4276@xxxxxxxxxxxxxxxxxxxxxxx
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
http://gregorybeamer.spaces.live.com

*************************************************
Think outside of the box!
*************************************************
"le0" <leo.tamisin@xxxxxxxxx> wrote in message
news:OpnZCy26GHA.4116@xxxxxxxxxxxxxxxxxxxxxxx
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\sample\App_Data\MyBooks.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.OleDb.OleDbException: The Microsoft Jet
database engine cannot open the file
'\\telsvr04\sample\App_Data\MyBooks.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







.

Relevant Pages

  • Re: System.Security.SecurityException was unhandled
    ... The exception gave you the CLSID. ... the first thing to check might be whether the COM server ... assembly actually has the permission in question. ... When I execute the application I received and error message. ...
    (microsoft.public.dotnet.security)
  • Object reference not set to an instance of an object.
    ... ASP.NET that uses web service for SQL Server 2000 DB access. ... Exception Details: System.NullReferenceException: Object reference not ... Dim myJobRequest As New skillsDB.jobRequest ... Session= "The skills database has been updated ...
    (microsoft.public.dotnet.framework.aspnet.webcontrols)
  • SerialisationException: Request for the permission of type failed.
    ... I'm getting a serialisation exception with an inner permission error ... TSI.DRICE.Interfaces (available to both client and server). ... t for the permission of type TSI.DRICE.Interfaces.EngineTypes failed. ... (Stream serializationStream, HeaderHandler handler, Boolean fCheck, ...
    (microsoft.public.dotnet.framework.remoting)
  • Re: dumb++ security
    ... If the user doesn't have permission ... > to connect to either database, ... Proud Member of the Exclusive "I have been plonked by Davee because he ... > database/some server to perform task A. ...
    (comp.security.misc)
  • Re: dumb++ security
    ... If the user doesn't have permission ... > to connect to either database, ... Proud Member of the Exclusive "I have been plonked by Davee because he ... > database/some server to perform task A. ...
    (comp.security.unix)