Really Stuck on VB Access in ASP

[Roger Stenson]

Hi
I have a web ASP application using Access 2000 format databases which I
developed in vb script on Windows 2000. The product works fine on IIS
in the development machine and was fairly widely used publically for
customer
demonstration with limited db's in a trial ISP using NT4.

The web product is supported by a back-office vb6 system used to build the
database for real. The database is now ready and the client wishes to go
live on the web

When we run the proven asp code on IIS in an XP Pro machine with the new
databases, it immediatly halts with the browser displaying a message from
the Jet Microsoft JET Database Engine "(0x80040E09) Cannot update. Database
or object is read-only." We get the the same message when we upload the
system and data to the chosen ISP who also uses NT4.
The database complained of is the "System database " which has already been
read from by global.asa on start up. The system fails on an 'Addnew'
instruction when
adding a log- in to the log file.

I have spent a lot of time pouring over ACCESS security texts and have three
versions of the database, one unsecured, one secured with all the update
functions cleared for use by everyone and one imported from the working
Windows 2k environment.
All three work fine in the Windows 2k IIS and with the back office VB
system. All three achieve the above error
when running on IIS on the XP machine and when uploaded to the new ISP.

As the ASP vb script specifically opens the Ado connection in read write
mode and has long been working, we can't believe it is the Asp code that is
the
problem.

So I have recently switche to looking at the IIS setups in W2k and XPPro
machines but can not find any differneces which look material to me. I
would be really grateful for some ideas on how to move this problem forward
or how to set about furthering the diagnosis. as I am at my wits end.

Roger Stenson

[Jeff Cochran]

On Fri, 5 Mar 2004 18:19:46 -0000, "Roger Stenson"
<roger.stenson1@ntlworld.com> wrote:

>Hi
>I have a web ASP application using Access 2000 format databases which I
>developed in vb script on Windows 2000. The product works fine on IIS
>in the development machine and was fairly widely used publically for
>customer
>demonstration with limited db's in a trial ISP using NT4.
>
>The web product is supported by a back-office vb6 system used to build the
>database for real. The database is now ready and the client wishes to go
>live on the web
>
>When we run the proven asp code on IIS in an XP Pro machine with the new
>databases, it immediatly halts with the browser displaying a message from
>the Jet Microsoft JET Database Engine "(0x80040E09) Cannot update. Database
>or object is read-only."

See:

[url]http://www.aspfaq.com/show.asp?id=2326[/url]
[url]http://www.aspfaq.com/show.asp?id=2062[/url]

Jeff

>We get the the same message when we upload the
>system and data to the chosen ISP who also uses NT4.
>The database complained of is the "System database " which has already been
>read from by global.asa on start up. The system fails on an 'Addnew'
>instruction when
>adding a log- in to the log file.
>
>I have spent a lot of time pouring over ACCESS security texts and have three
>versions of the database, one unsecured, one secured with all the update
>functions cleared for use by everyone and one imported from the working
>Windows 2k environment.
>All three work fine in the Windows 2k IIS and with the back office VB
>system. All three achieve the above error
>when running on IIS on the XP machine and when uploaded to the new ISP.
>
>As the ASP vb script specifically opens the Ado connection in read write
>mode and has long been working, we can't believe it is the Asp code that is
>the
>problem.
>
>So I have recently switche to looking at the IIS setups in W2k and XPPro
>machines but can not find any differneces which look material to me. I
>would be really grateful for some ideas on how to move this problem forward
>or how to set about furthering the diagnosis. as I am at my wits end.
>
>Roger Stenson
>
>
>