I get the message: 'Could not use ''; file already in use.' on my pages if I
am working in the database. I used to be able work in the database (Access)
and users use the site, but I tried to install Remote Debugging tools from
VStudio 2k3 and since then it has been messed up.
Please, this is very important for us to fix. We are having errors if two or
more people are on the site at the same time. 10 3033
Hi Mark,
This error usually happens on Windows NT, Windows 2000 or Windows XP and
may be caused by any of the following conditions:
- the database file or database folder doesn't have necessary security
permissions to write to, or erase an .ldb file created by Microsoft Access
when opening the database
- the database file doesn't have sufficient security permissions or write
permissions to be modified when updating data in it. The web browser is
seen by the web server as an Internet User (IUSR or ASPNET account. It
depends on the configurations of the web application). This user needs to
have write permission to the database file and to the database folder.
For the possible solution, please check the following URL: http://support.codecharge.com/kb_art...p?article_id=4
If the problem still exists, there is a tool that can allow you to identify
any specific files or folders that are giving an access denied. The tool is
called FileMon. http://www.sysinternals.com/ntw2k/source/filemon.shtml
Filemon is simple to use and will show file accesses of all kinds. Try to
reproduce the error while capturing the events and hopefully find some
"access denied" messages in the logs.
Note:
The third-party products that are discussed in this article are
manufactured by companies that are independent of Microsoft. Microsoft
makes no warranty, implied or otherwise, regarding the performance or
reliability of these products.
I hope it helps.
Best regards
Jacob Yang
Microsoft Online Partner Support
Get Secure! ¨C www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Thank you. This does not happen all the time. For the most part, this web
application can access the database. It is only when there are 2 or more
requests for access to the database that I recieve this error. But this has
not always been the case. I do believe it is a security issue, but it seems
that everything has the correct security. The database is simply not
allowing concurrent access.
"Jacob Yang [MSFT]" <ji***@online.microsoft.com> wrote in message
news:N1**************@cpmsftngxa06.phx.gbl... Hi Mark,
This error usually happens on Windows NT, Windows 2000 or Windows XP and may be caused by any of the following conditions:
- the database file or database folder doesn't have necessary security permissions to write to, or erase an .ldb file created by Microsoft Access when opening the database - the database file doesn't have sufficient security permissions or write permissions to be modified when updating data in it. The web browser is seen by the web server as an Internet User (IUSR or ASPNET account. It depends on the configurations of the web application). This user needs to have write permission to the database file and to the database folder.
For the possible solution, please check the following URL:
http://support.codecharge.com/kb_art...p?article_id=4
If the problem still exists, there is a tool that can allow you to
identify any specific files or folders that are giving an access denied. The tool
is called FileMon.
http://www.sysinternals.com/ntw2k/source/filemon.shtml
Filemon is simple to use and will show file accesses of all kinds. Try to reproduce the error while capturing the events and hopefully find some "access denied" messages in the logs.
Note: The third-party products that are discussed in this article are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, regarding the performance or reliability of these products.
I hope it helps.
Best regards
Jacob Yang Microsoft Online Partner Support Get Secure! ¨C www.microsoft.com/security This posting is provided "as is" with no warranties and confers no rights.
BTW, FileMon tells me there is a Sharing Violation when this happens, on an
Open Access: All
"Jacob Yang [MSFT]" <ji***@online.microsoft.com> wrote in message
news:N1**************@cpmsftngxa06.phx.gbl... Hi Mark,
This error usually happens on Windows NT, Windows 2000 or Windows XP and may be caused by any of the following conditions:
- the database file or database folder doesn't have necessary security permissions to write to, or erase an .ldb file created by Microsoft Access when opening the database - the database file doesn't have sufficient security permissions or write permissions to be modified when updating data in it. The web browser is seen by the web server as an Internet User (IUSR or ASPNET account. It depends on the configurations of the web application). This user needs to have write permission to the database file and to the database folder.
For the possible solution, please check the following URL:
http://support.codecharge.com/kb_art...p?article_id=4
If the problem still exists, there is a tool that can allow you to
identify any specific files or folders that are giving an access denied. The tool
is called FileMon.
http://www.sysinternals.com/ntw2k/source/filemon.shtml
Filemon is simple to use and will show file accesses of all kinds. Try to reproduce the error while capturing the events and hopefully find some "access denied" messages in the logs.
Note: The third-party products that are discussed in this article are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, regarding the performance or reliability of these products.
I hope it helps.
Best regards
Jacob Yang Microsoft Online Partner Support Get Secure! ¨C www.microsoft.com/security This posting is provided "as is" with no warranties and confers no rights.
Are you sure that ASP.NET account has "Create File" permission on folder
where database(mdb file) is?
It's important because otherwise the ldb file can not be created. And
database is open in exclusive mode by first connection?
George.
"M K" <ma**@nospamcenturycolor.com> wrote in message
news:u6**************@TK2MSFTNGP11.phx.gbl... Thank you. This does not happen all the time. For the most part, this web application can access the database. It is only when there are 2 or more requests for access to the database that I recieve this error. But this
has not always been the case. I do believe it is a security issue, but it
seems that everything has the correct security. The database is simply not allowing concurrent access.
"Jacob Yang [MSFT]" <ji***@online.microsoft.com> wrote in message news:N1**************@cpmsftngxa06.phx.gbl... Hi Mark,
This error usually happens on Windows NT, Windows 2000 or Windows XP and may be caused by any of the following conditions:
- the database file or database folder doesn't have necessary security permissions to write to, or erase an .ldb file created by Microsoft
Access when opening the database - the database file doesn't have sufficient security permissions or
write permissions to be modified when updating data in it. The web browser is seen by the web server as an Internet User (IUSR or ASPNET account. It depends on the configurations of the web application). This user needs
to have write permission to the database file and to the database folder.
For the possible solution, please check the following URL:
http://support.codecharge.com/kb_art...p?article_id=4
If the problem still exists, there is a tool that can allow you to identify any specific files or folders that are giving an access denied. The tool is called FileMon.
http://www.sysinternals.com/ntw2k/source/filemon.shtml
Filemon is simple to use and will show file accesses of all kinds. Try
to reproduce the error while capturing the events and hopefully find some "access denied" messages in the logs.
Note: The third-party products that are discussed in this article are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, regarding the performance or reliability of these products.
I hope it helps.
Best regards
Jacob Yang Microsoft Online Partner Support Get Secure! ¨C www.microsoft.com/security This posting is provided "as is" with no warranties and confers no
rights.
Yes, it has create rights. It can create the LDB, but I believe it is
opening it in exclusive mode. My connection string hasn't changed tho.
"George Ter-Saakov" <no****@hotmail.com> wrote in message
news:OO****************@TK2MSFTNGP12.phx.gbl... Are you sure that ASP.NET account has "Create File" permission on folder where database(mdb file) is?
It's important because otherwise the ldb file can not be created. And database is open in exclusive mode by first connection?
George.
"M K" <ma**@nospamcenturycolor.com> wrote in message news:u6**************@TK2MSFTNGP11.phx.gbl... Thank you. This does not happen all the time. For the most part, this
web application can access the database. It is only when there are 2 or more requests for access to the database that I recieve this error. But this has not always been the case. I do believe it is a security issue, but it seems that everything has the correct security. The database is simply not allowing concurrent access.
"Jacob Yang [MSFT]" <ji***@online.microsoft.com> wrote in message news:N1**************@cpmsftngxa06.phx.gbl... Hi Mark,
This error usually happens on Windows NT, Windows 2000 or Windows XP
and may be caused by any of the following conditions:
- the database file or database folder doesn't have necessary security permissions to write to, or erase an .ldb file created by Microsoft Access when opening the database - the database file doesn't have sufficient security permissions or write permissions to be modified when updating data in it. The web browser
is seen by the web server as an Internet User (IUSR or ASPNET account. It depends on the configurations of the web application). This user needs to have write permission to the database file and to the database folder.
For the possible solution, please check the following URL:
http://support.codecharge.com/kb_art...p?article_id=4
If the problem still exists, there is a tool that can allow you to identify any specific files or folders that are giving an access denied. The
tool is called FileMon.
http://www.sysinternals.com/ntw2k/source/filemon.shtml
Filemon is simple to use and will show file accesses of all kinds. Try to reproduce the error while capturing the events and hopefully find some "access denied" messages in the logs.
Note: The third-party products that are discussed in this article are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, regarding the performance or reliability of these products.
I hope it helps.
Best regards
Jacob Yang Microsoft Online Partner Support Get Secure! ¨C www.microsoft.com/security This posting is provided "as is" with no warranties and confers no rights.
Hi Mark,
I am sorry if there is any misunderstanding but you have mentioned that
"The database is simply not allowing concurrent access".
As I understand, it means that "The ACCESS DB was configured not to be
allowed concurrent access". Is it correct?
If I have misunderstood your concern, please feel free to let me know.
Best regards,
Jacob Yang
Microsoft Online Partner Support
Get Secure! ¨C www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
The database was working fine until I tried to install Visual Studio Remote
Debugging tools (2003) on that system. After that I started getting these
messages. I don't know what was configured differently, VS Remote Debugging
just went through and started changing permissions. And when I uninstalled,
not everything was fixed. So now I have my Access DB problem. So yes, I
guess (because I don't know) that access DB was configured not to be allowed
concurrent access.
"Jacob Yang [MSFT]" <ji***@online.microsoft.com> wrote in message
news:MB**************@cpmsftngxa06.phx.gbl... Hi Mark,
I am sorry if there is any misunderstanding but you have mentioned that "The database is simply not allowing concurrent access".
As I understand, it means that "The ACCESS DB was configured not to be allowed concurrent access". Is it correct?
If I have misunderstood your concern, please feel free to let me know.
Best regards,
Jacob Yang Microsoft Online Partner Support Get Secure! ¨C www.microsoft.com/security This posting is provided "as is" with no warranties and confers no rights.
Hi Mark,
I agreed that it should be a security issue. Have you tried the fix steps
listed in the following article? http://support.codecharge.com/kb_art...p?article_id=4
1. Check with the host that the user running the ASP.NET web app, usually
it is ASPNET account, has the correct permissions on the database and the
folder containing the database.
2. Try to open the MDB file in Access and choose compact and repair from
the tools menu.
3. Please make sure in the asp.net code, the connection to the MDB file was
closed each time we finished the operations on the db file.
Please help to double check the steps above. I certainly appreciate your
time.
Best regards,
Jacob Yang
Microsoft Online Partner Support
Get Secure! ¨C www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Yes, the security is still correct. (Both ASP.NET and IUSR have Modify and
Write rights to the folder, the file, and the temp folder.) It is not just
my ASP.NET app. It affects all users on our network as well. Only one user
can access it at a time. I tried compacting the database, and get this
message now:
The Microsoft Jet database engine cannot open the file
'C:\inetpub\CCLWeb\databases\webForm.mdb'. It is already opened exclusively
by another user, or you need permission to view its data.
"Jacob Yang [MSFT]" <ji***@online.microsoft.com> wrote in message
news:iE**************@cpmsftngxa06.phx.gbl... Hi Mark,
I agreed that it should be a security issue. Have you tried the fix steps listed in the following article?
http://support.codecharge.com/kb_art...p?article_id=4
1. Check with the host that the user running the ASP.NET web app, usually it is ASPNET account, has the correct permissions on the database and the folder containing the database. 2. Try to open the MDB file in Access and choose compact and repair from the tools menu. 3. Please make sure in the asp.net code, the connection to the MDB file
was closed each time we finished the operations on the db file.
Please help to double check the steps above. I certainly appreciate your time.
Best regards,
Jacob Yang Microsoft Online Partner Support Get Secure! ¨C www.microsoft.com/security This posting is provided "as is" with no warranties and confers no rights.
Hi Mark,
Thank you for your update. More information is needed before my further
research.
1. How do you open the access database? Would you please show the code for
opening the access database? Based on the error message, the mdb file is
already opened exclusively.
2. When you tried to compact the database, does the database file was
already opened by other users? Please make sure that all other users have
logged out and test it again.
3. Please tell me the version of your access database.
4. Does the problem only occur in this specific database? Have you tried to
test some default access database files?
I certainly appreciate your time.
Best regards,
Jacob Yang
Microsoft Online Partner Support
Get Secure! ¨C www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Koen |
last post by:
Hi all,
I created a little database to manage my e-books.
The program will synchronize a table with the contents of a directory.
Works great.
Because I keep additional info (like keywords) to...
|
by: Ney André de Mello Zunino |
last post by:
Hello.
I would appreciate if somebody could assist me with an error message I
am getting from the Microsoft WinDbg 6.3 debugging tool. I am not
familiar with it, since I have just downloaded it....
|
by: yma |
last post by:
Hi,
I tried to use a listbox to display a column in MS Access 2000 nwind.mdb by
using ole DataAdapter, Connection and dataset controls. But I got "It is
already opened exclusively by another...
|
by: Miro |
last post by:
I've read a couple of threads on this error but none of them could help me so
I'm posting myself.
When I try open and read (not update) an ACCESS database on a network share
I occasionally get:...
|
by: Jim |
last post by:
Hello,
I would like to find every occurrence of the string "://" in the index.dat
files which store the ie history. Once a line is identified as containing
this string, I would process (i.e....
|
by: Bob |
last post by:
Cannot copy assembly '<...>' to file <...>.dll'. The process cannot access
the file because it is being used by another process.
Could not copy temporary files to the output directory.
The file...
|
by: Learner |
last post by:
Hi there,
I am trying to access the access database sitting at
OleDbConnection oleConn = new
OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\\Program Files\\Microsoft Visual...
|
by: thinktwice |
last post by:
i have just made a test project :(win32 console)
//file : func.h
#ifndef _FUNC_H_
#define _FUNC_H_
void func1()
{
return;
};
|
by: Andy |
last post by:
Thanks Peter,
I thought I'd give an update on this problem. My application had 2
assemblies that contained classed for the Data access and business
logic layer. It was on one of them that I was...
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
| |