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
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

  • Session_End event, System.NullReferenceException
    ... database table that is used to log user sessions. ... The stored procedure executes successfully, and I can see the updated data in ... an exception is being generated by the code that I'ved added to ... through an execution of the code that led to the exception. ...
    (microsoft.public.dotnet.framework.aspnet)
  • ASP.NET 2.0 Web Page Problem?
    ... I have obtained a scripted database and compiled ASP.NET 2.0 application from a sister site that I'm trying to implement locally. ... The issue is, on one particular page that has two dropdown listboxes, where second was is populated with a list of customer numbers after the "group" is selected from the first dropdown appears to be throwing an ASP.NET exception error. ... An unhandled exception occurred during the execution of the current web request. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Enterprise Library and PostgreSQL (Npgsql)
    ... I found the database provider code at ... Catch ex As Exception ... If the connection string is invalid or the database server is ... Microsoft MSDN Online Support Lead ...
    (microsoft.public.dotnet.framework)
  • OWC10.ChartSpaceClass.ExportPicture - Access Denied Error
    ... An unhandled exception has occurred during the execution of the current web request. ... Information regarding the origin and location of the exception can be idenitifed using exception stack trace below. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: ASP.NET 2.0 Web Page Problem?
    ... I actually found out that the problem wasn't the repeater control or anything. ... You sister site might be hiding the exception by logging it or ignoring them somehow, I'd need to see the code to say for sure. ... I have obtained a scripted database and compiled ASP.NET 2.0 application from a sister site that I'm trying to implement locally. ... An unhandled exception occurred during the execution of the current web request. ...
    (microsoft.public.dotnet.framework.aspnet)

Loading