473,687 Members | 3,786 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Concurrent Web- and direct access to an Access DB

CJM
I'm setting up some web-based (ASP) reports that query an Access DB. I also
want certain people to be able to access and manipulate the database
directly.

However, if the database is open in Access, I cant access it via ASP:

Microsoft JET Database Engine error '80004005'
Could not use ''; file already in use.

Is there anyway the web application and direct-access users can peacefully
coexist? I know Access isnt really strong on concurrent access, but I figure
it ought to at least be able to handle this...

Thanks

Chris
Jul 19 '05 #1
12 2379
CJM wrote:
I'm setting up some web-based (ASP) reports that query an Access DB.
I also want certain people to be able to access and manipulate the
database directly.

However, if the database is open in Access, I cant access it via ASP:

Microsoft JET Database Engine error '80004005'
Could not use ''; file already in use.

Is there anyway the web application and direct-access users can
peacefully coexist? I know Access isnt really strong on concurrent
access, but I figure it ought to at least be able to handle this...


This IS covered at http://www.aspfaq.com/show.asp?id=2009 - 80004005 errors

All users of a Jet database need read/write (Change) permissions for the
folder containing the database. This includes the IUSR account.

Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
Jul 19 '05 #2
CJM

"Bob Barrows [MVP]" <re******@NOyah oo.SPAMcom> wrote in message
news:%2******** ********@TK2MSF TNGP11.phx.gbl. ..
CJM wrote:
I'm setting up some web-based (ASP) reports that query an Access DB.
I also want certain people to be able to access and manipulate the
database directly.

However, if the database is open in Access, I cant access it via ASP:

Microsoft JET Database Engine error '80004005'
Could not use ''; file already in use.

Is there anyway the web application and direct-access users can
peacefully coexist? I know Access isnt really strong on concurrent
access, but I figure it ought to at least be able to handle this...

This IS covered at http://www.aspfaq.com/show.asp?id=2009 - 80004005

errors
All users of a Jet database need read/write (Change) permissions for the
folder containing the database. This includes the IUSR account.

Bob Barrows


It IS covered, however, it DOESNT solve my problem, hence the reason I
posted...
Jul 19 '05 #3
CJM wrote:
"Bob Barrows [MVP]" <re******@NOyah oo.SPAMcom> wrote in message
news:%2******** ********@TK2MSF TNGP11.phx.gbl. ..
CJM wrote:
I'm setting up some web-based (ASP) reports that query an Access DB.
I also want certain people to be able to access and manipulate the
database directly.

However, if the database is open in Access, I cant access it via
ASP:

Microsoft JET Database Engine error '80004005'
Could not use ''; file already in use.

Is there anyway the web application and direct-access users can
peacefully coexist? I know Access isnt really strong on concurrent
access, but I figure it ought to at least be able to handle this...


This IS covered at http://www.aspfaq.com/show.asp?id=2009 - 80004005
errors

All users of a Jet database need read/write (Change) permissions for
the folder containing the database. This includes the IUSR account.

Bob Barrows


It IS covered, however, it DOESNT solve my problem, hence the reason I
posted...


Sorry, I missed the part in your original post where you said you had read
this article ... ;-)

As long as all users (including the IUSR and IWAM accounts) have filesystem
permissions to the folder containing the database, there should be no
problem. It works fine for me. I guess you need to provide some more
information.

Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
Jul 19 '05 #4
Hello,

In MS Access, if you choose "Open Read only" to open the access file, will
you open it in ASP? If you only need to query the Access database, you may
add "Mode=Read; " in the connection string. Will this help

Luke
Jul 19 '05 #5
CJM
"Bob Barrows [MVP]" <re******@NOyah oo.SPAMcom> wrote in message
news:OP******** ******@TK2MSFTN GP12.phx.gbl...
As long as all users (including the IUSR and IWAM accounts) have filesystem permissions to the folder containing the database, there should be no
problem. It works fine for me. I guess you need to provide some more
information.


I'm going to check all my facts this morning just to make sure I havent
missed anything.. I'll repost when I have confirmed what is happening.

tx

CJM
Jul 19 '05 #6
CJM
Luke,

I've already tried this. Well, rather than modify my connections string, I
set the connection objects mode property instead, which should have the same
effect - but didnt.

As I said to Bob, I'll check for loose ends and will repost shortly...

Chris

"[MSFT]" <lu******@onlin e.microsoft.com > wrote in message
news:28******** ******@cpmsftng xa06.phx.gbl...
Hello,

In MS Access, if you choose "Open Read only" to open the access file, will
you open it in ASP? If you only need to query the Access database, you may
add "Mode=Read; " in the connection string. Will this help

Luke

Jul 19 '05 #7
CJM
Still no nearer a solution...

As I understand it, I should be able to access & edit the DB via MS Access
at the same time that a web app accesses the the DB (read only). Obviously,
if the web app tries to access records opened in the MS Access application,
an error is expected...

KB174943 (http://support.microsoft.com/?id=174943) states that the IUSR user
needs sufficient privileges; for both my development machine (XP) and the
live server (Win2k3), the IUSR user has Full rights to the whole application
directory. Indeed, I even added the IUSR user on the XP machine to the local
administrators group.

If I open the DB in Access as Read Only, I can run the web app at the same
time.

Any further thoughts or ideas?

Chris
Jul 19 '05 #8
CJM wrote:
Still no nearer a solution...

As I understand it, I should be able to access & edit the DB via MS
Access at the same time that a web app accesses the the DB (read
only). Obviously, if the web app tries to access records opened in
the MS Access application, an error is expected...

KB174943 (http://support.microsoft.com/?id=174943) states that the
IUSR user needs sufficient privileges; for both my development
machine (XP) and the live server (Win2k3), the IUSR user has Full
rights to the whole application directory. Indeed, I even added the
IUSR user on the XP machine to the local administrators group.

If I open the DB in Access as Read Only, I can run the web app at the
same time.

Any further thoughts or ideas?

Chris


If the web application's protection setting is High(Isolated). then the IWAM
account is the user, not the IUST account, and therefore it needs Change
permissions for the folder containing the database. The issue is that all
users of the database file need to have the ability to create, modify, and
delete the .lck (lock) file in that same directory/folder. "Full"
permissions is not needed, only Change permissions. Don't go crazy here:
users do not need to be administrators, or anything that extreme. They do
not need to have permissions for the whole application folder. They need to
be able to Change files in the database folder. If you have granted them
those permissions and it is still not working, then more permissions is not
the answer.

Are we dealing with a database on a remote machine? If so, the IUSR account
has to become a domain user.

Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
Jul 19 '05 #9
CJM

"Bob Barrows [MVP]" <re******@NOyah oo.SPAMcom> wrote in message
news:uU******** ******@TK2MSFTN GP09.phx.gbl...
If the web application's protection setting is High(Isolated). then the IWAM account is the user, not the IUST account, and therefore it needs Change
permissions for the folder containing the database. The issue is that all
users of the database file need to have the ability to create, modify, and
delete the .lck (lock) file in that same directory/folder. "Full"
permissions is not needed, only Change permissions. Don't go crazy here:
users do not need to be administrators, or anything that extreme. They do
not need to have permissions for the whole application folder. They need to be able to Change files in the database folder. If you have granted them
those permissions and it is still not working, then more permissions is not the answer.

The application protection is set to Medium (Pooled).

The KB article suggest assigning the IUSR user to the local administrators
group as a quick check. Needless to say, it won't be left that way.
Are we dealing with a database on a remote machine? If so, the IUSR account has to become a domain user.


No... in both cases the DB is local to the web server.

[However, I will soon have to access an Access DB on a remote machine to
I've made a mental note about the domain user issue - thanks]

Chris
Jul 19 '05 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
5481
by: Dave Kissoondoyal | last post by:
We are running three web sites in a clustered environment WLBS. The web servers are connected to a Database Server running MS SQL server enterprise edition licensed as per CPU license. The Windows 2000 Advanced Server Licensing mode on all the servers is per SEAT license. Our customers are accessing our web servers and after some time getting error 500, Maximum concurrent users have reached.
0
1950
by: Volkan Arslan | last post by:
------------------------------------------------------------- LASER Summer School on Software Engineering Software engineering for concurrent and real-time systems Elba, Italy September 11 - 17, 2005 http://se.inf.ethz.ch/laser -------------------------------------------------------------
1
3611
by: TroutyJoe | last post by:
Hi all, For performance reasons, I would like to restrict concurrent request to a WebService that I provide, so that only a single request to a WebService can run at any time, with all other requests going into the request queue. I have tried editing thread settings in the machine.config e.g: processModel - maxWorkerThreads="1" maxIoThreads="1"
6
2487
by: Max2006 | last post by:
Hi, I am trying to make our business logic layer components more efficient. We use strongly typed datasets and TableAdapters. Is it a good idea to use a static TableAdpater to share the static instance among all sessions? My business logic components are like this:
10
4498
by: Frankie | last post by:
It appears that System.Random would provide an acceptable means through which to generate a unique value used to identify multiple/concurrent asynchronous tasks. The usage of the value under consideration here is that it is supplied to the AsyncOperationManager.CreateOperation(userSuppliedState) method... with userSuppliedState being, more or less, a taskId. In this case, the userSuppliedState {really taskId} is of the object type,...
0
8524
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9066
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
8779
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
1
6450
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5806
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4321
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4541
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
2214
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
1947
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.