IIS 6 and Windows Script - database conflict

External Since: Feb 07, 2005 Posts: 1

I have a website running ASP on a Windows Server 2003 that uses a MS
Access database. I also have some Windows Scripts that use the same
database as above.

The problem I have is that, whenever I run a windows script that
access the database, all ASP pages returns errors that it cannot use
the database (file already in use). Both ASP and WS-files read & write
to the db, and they all work fine - just not when I run them at the
same time.

The thing is, that everything worked just fine when I used Windows
2000 Server.

I figure this must have something to do with permissions of some kind.

I have tried different connection-methods to the db but they all give
back the same error. I have set the permissions so that IUSR_COMP and
NETWORK SERVICES both have read & write permissions.

The WS-files run as COMP\Administrator.

Any ideas?

/Peter

External Since: Jun 10, 2004 Posts: 1807

On 7 Feb 2005 02:34:48 -0800, peter.RemoveThis@cevican.com (Peter Tellram) wrote:

>I have a website running ASP on a Windows Server 2003 that uses a MS
>Access database. I also have some Windows Scripts that use the same
>database as above.
>
>The problem I have is that, whenever I run a windows script that
>access the database, all ASP pages returns errors that it cannot use
>the database (file already in use). Both ASP and WS-files read & write
>to the db, and they all work fine - just not when I run them at the
>same time.
>
>The thing is, that everything worked just fine when I used Windows
>2000 Server.
>
>I figure this must have something to do with permissions of some kind.
>
>I have tried different connection-methods to the db but they all give
>back the same error. I have set the permissions so that IUSR_COMP and
>NETWORK SERVICES both have read & write permissions.
>
>The WS-files run as COMP\Administrator.
>
>Any ideas?

Post full errors, in the asp.db group. And keep in mind that Access
is notrious for problems related to multiple users attempting to
access the database at the same time.

Jeff