mdb read-only -- not the normal problems

I have an mdb that I open using asp.net. I edit these pages and code
using FrontPage.

Everything works fine, but sometimes I make a mistake in my code, and
my page errors out before I close the DB connection. When this happens,
sometimes, the mdb becomes read only, as in when I open the mdb by
double clicking, I get "The database <name> is read-only" pop up.

If I try to edit via Front Page, I can, but FP cannot update the mdb,
because it is read only. (I understand all that).

Usually, this resolves itself auto-magically in a couple of hours. My
question is, how can I resolve it myself?

Also, I can go to a page with no errors, and run the page no problem,
code opens a db con, gets data, and closes it. I did this in the hope
that the IIS user close any locks they had on the db if I did a
succesfull con.close. This does not work.

Thanks for any help or advice.

I posted this in ado forum because I think it is my code causing the
problem, I just can't fix it.

.

Relevant Pages

  • mdb read only - not the usual problems
    ... I have an mdb that I open using asp.net. ... If I try to edit via Front Page, I can, but FP cannot update the mdb, ... this resolves itself auto-magically in a couple of hours. ... code opens a db con, gets data, and closes it. ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: Access to Access Automatic Updates
    ... Then navigate to the database from the File Open dialog and open it. ... You will need to do it for mdb that has tables you need ... MS Office Master 2000 ed. ... you will need to create a form that opens on ...
    (microsoft.public.access.externaldata)
  • RE: Access to Access Automatic Updates
    ... MS Office Master 2000 ed. ... Then navigate to the database from the File Open dialog and open it. ... You will need to do it for mdb that has tables you need ... you will need to create a form that opens on ...
    (microsoft.public.access.externaldata)
  • RE: security wizard cannot be run
    ... secure mdb while joined to system.mdw. ... database is very secure) ... Open Access (no mdb). ... Once the database opens, the ...
    (microsoft.public.access.security)
  • RE: Code not importing with forms
    ... I went through the process of importing all objects into a new blank ... database again today and it worked fine. ... Click on the tool bar button that opens the form module. ... blank mdb and then importing all objects from the corrupt mdb. ...
    (microsoft.public.access.externaldata)