By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,677 Members | 1,877 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,677 IT Pros & Developers. It's quick & easy.

error in accessing database

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a
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.