Re: Help connecting to Access DB from web service

Hello Steve,

Thank you for your reply.

I would love to move the database to SQL Express but that is not an option
since the desktop application is a comerical application and its native file
format is Access.

Given that I can not move the data to a better database, what can be done to
make my web service work well with the Access db while hosted on IIS? Can
the worker process for this application be given additional permission?

Thanks,
Jeff.
"Steven Cheng[MSFT]" <stcheng@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:dDnfoNvVGHA.1480@xxxxxxxxxxxxxxxxxxxxxxxx
Hi Jeff,

Welcome to the MSDN newsgroup.

Regarding on the accessing Access mdb database in ASP.NET application, it
is likely the ASP.NET application doesn't have sufficient permission or
the
mdb file is locked. From your description, you've another desktop
application that will also open and access the mdb file, if so, I'm
afraid
the ASP.NET application hosted in IIS will not be able to access it
concurently (if get locked). This is different when accessing from local
computer or in testserver because when deploying in IIS, the asp.net
appliation runs under the asp.net worker process (under the worker proces
indenitity) and this process's security session is not a interactive
session which can not perform many action like desktop application. So
for
your scenario, I think you may consider the following options:

1. Do not make other application access the same mdb file concurrently
that
make it get locked.

2. Use SQL express db instead, this is also file based however is
designed
for concorrent server-side application and has much better performance
against access.

Regards,

Steven Cheng
Microsoft Online Community Support


==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================


This posting is provided "AS IS" with no warranties, and confers no
rights.



Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)


.

Relevant Pages

  • Re: Database for a WM5 device
    ... It sounds like I can use SQL CE on my WM5 device. ... CE database on the desktop. ... I noticed on my old PPC 2002 device that I could upload .mdb file to and ...
    (microsoft.public.pocketpc.developer)
  • Re: Back-to-front introduction needed
    ... >about database design principles. ... OK let me explain that naive question: If I think about the Access ... then is the database the .mdb file in an isolated sense or is it ... And then what about SQL, which I've little direct experience of? ...
    (microsoft.public.dotnet.framework.adonet)
  • Linked server to Access problem
    ... I have linked server to Access database on my SQL 2000 ... The mdb file is on another ...
    (microsoft.public.sqlserver.security)
  • Intermitant Reserved error (-3034)
    ... It doesn't seem to tied to any particular database call, ... ..Description = Reserved error; there is no message for this error. ... This turned up after we changed to accessing the data through an .mdb file ... that is linked to an SQL 2000 database. ...
    (microsoft.public.vb.database.dao)
  • Re: dbdebunk Quote of Week comment
    ... > a lot of really bad SQL programmers. ... But SQL does not have a pointer data type or the ... > being told to design a database. ... But why is little Cindy Lou Who employee ...
    (comp.databases.theory)