Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP General > Concurrent Web- and direct access to an Access DB

Thread Tools

Concurrent Web- and direct access to an Access DB

Dave Anderson
Posts: n/a
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.

Reply With Quote
Posts: n/a
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:


Reply With Quote
Posts: n/a
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

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/


"CJM" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> I'm setting up some web-based (ASP) reports that query an Access DB. I

> 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

> it ought to at least be able to handle this...
> Thanks
> Chris

Reply With Quote

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Concurrent Access to same Session wrt Lock Time-out - what is it? Kevin Frey ASP .Net 3 03-06-2008 10:54 PM
ejbs and concurrent access to share data Andreas Bauer Java 0 04-26-2006 02:48 PM
problems locating the concurrent EDU.oswego.cs.dl.util.concurrent package Pep Java 6 08-16-2005 07:26 AM
Concurrent access null session/application objects Ben Java 1 04-15-2005 07:38 PM
Cache Object Concurrent Access Manit Chanthavong ASP .Net 2 11-19-2003 07:31 PM