Updating Access database used by ISAPI DLL

From: Bernard Taylor (bernard.taylor_at_spamfritter.gtech.com)
Date: 01/24/05 

Date: 24 Jan 2005 07:42:03 -0800

I have an ISAPI DLL that reads an Access database. The DLL is
written in D7 and runs under IIS6 on a W2003 server.

Before the dll is loaded, the database is accessible through the
normal Access software and can be updated.

Once the dll has been activated, the database cannot be updated
through Access until the web service is stopped. As we require
manual updates and the service should be available at all times,
I am trying to find a solution to this problem.

Although the ADOConnection is kept open until the WebModule is
destroyed, I have set LockType to ltReadonly on all my ADO
components and the ADOConnection mode is set to cmRead, so I did
not expect any locking to take place.

Does anyone know how to get round this problem?

TIA
Bernard

Relevant Pages

  • New to n-tier (C# Web app / ASP.NET 1.1)
    ... My question in summary is "how do I call my data access ... for SQL server - the only places in the project where connection to the ... database is made), in their own folder within the VS project, therefore ... compiled into the one single dll with the rest of the app. ...
    (microsoft.public.dotnet.distributed_apps)
  • Re: Class instancing
    ... What I am presently trying to do is to create a DLL, ... > work-arounds that I can see to get around the automatic changing of the ... Create the DLL and use this as a Reference library in your database ... Copy the class from the library database and paste it into any ...
    (microsoft.public.access.modulesdaovba)
  • Re: VB DLL wont die
    ... I have a VB DLL which I wrote as part of a VB application. ... little of the VB graphic interface, and more intensive database ... I keep feeding the class PKs from the recordset, ... stopped execution there, I couldn't seem to get out of that event. ...
    (microsoft.public.vb.general.discussion)
  • Re: VB DLL wont die
    ... all), which lets the user input a bunch of data, then does the calculations ... It also saves the raw data into an Access database, ... from which it can retrieve old records and spit out the report again. ... I had developed a VB DLL which took care of all the database interactions, ...
    (microsoft.public.vb.general.discussion)
  • Re: How to handle custom-messages in VBA from a custom C++ DLL
    ... > start other threads when called external functions from a DLL when using ... If some component is doing an operation on the database, ... Are you saying that you are having a *modeless* dialog box? ... or use a separate process. ...
    (microsoft.public.vc.language)