469,336 Members | 6,062 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,336 developers. It's quick & easy.

error in accessing database

le0
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

Oct 9 '06 #1
2 1891
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" <le*********@gmail.comwrote in message
news:Op**************@TK2MSFTNGP03.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\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

Oct 9 '06 #2
le0
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)" <No************@comcast.netNoSpamMwrote in
message news:OP**************@TK2MSFTNGP04.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
http://gregorybeamer.spaces.live.com

*************************************************
Think outside of the box!
*************************************************
"le0" <le*********@gmail.comwrote in message
news:Op**************@TK2MSFTNGP03.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\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


Oct 10 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by jim | last post: by
10 posts views Thread by Brian Conway | last post: by
13 posts views Thread by Praveen_db2 | last post: by
2 posts views Thread by GCM | last post: by
3 posts views Thread by Nathan Sokalski | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.