473,326 Members | 2,148 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

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 2341
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******@NOyahoo.SPAMcom> wrote in message
news:%2****************@TK2MSFTNGP11.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******@NOyahoo.SPAMcom> wrote in message
news:%2****************@TK2MSFTNGP11.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******@NOyahoo.SPAMcom> wrote in message
news:OP**************@TK2MSFTNGP12.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******@online.microsoft.com> wrote in message
news:28**************@cpmsftngxa06.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******@NOyahoo.SPAMcom> wrote in message
news:uU**************@TK2MSFTNGP09.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
CJM wrote:
Still no nearer a solution...

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


Have you tried simply linking to it? I inherited an Access-based ASP
application, and whenever I want to mess with the data, I open a local
Access DB and link to the one on the web server (File : Get External Data :
Link Tables). I can make changes through either interface without
interfering with the other.
--
Dave Anderson

Unsolicited commercial email will be read at a cost of $500 per message. Use
of this email address implies consent to these terms. Please do not contact
me directly or ask me to contact you directly for assistance. If your
question is worth asking, it's worth posting.
Jul 19 '05 #11
Hi Chris,

Is the access file also under \inetpub\wwwroot ? If so, you may try to move
it out to see if this will help. Furthermore, I suggest you may trace the
file access with a utility "Filemon". It can record all access to the
files. If you can find a "Access denied" error in the log, we can know if
there is any file/directory we need to grant permission for IUSER. Here is
the link for download it:

http://www.sysinternals.com/ntw2k/source/filemon.shtml

Luke

Jul 19 '05 #12
CJM
Yet again for unknown reasons the problem has disappeared!

I had set the connection to read only which should have solved the problem,
but initially it didnt appear to. However, when I came back to it yesterday,
it seemed to work OK.

Incidently, I tried Dave's solution which also worked fine, though it seemed
to be avoiding the problem rather than solving it (nothing wrong with that I
suppose).

AFAIK, I shouldnt need to set the connection mode to read only, but it works
so I'll stick with it.

Thanks to Luke/Bob for your efforts/

Chris

"CJM" <cj*******@newsgroups.nospam> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...
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 #13

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

Similar topics

1
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...
0
by: Volkan Arslan | last post by:
------------------------------------------------------------- LASER Summer School on Software Engineering Software engineering for concurrent and real-time systems Elba, Italy September 11 -...
1
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...
6
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...
10
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...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
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 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.