.NET application exported from Access works locally but not on webserver.

[Andy]

We have an ASP.NET application exported from MS Access 2003.
I uses a series of queries to generate a page showing todays bookings.

It works locally but does not work when we put it on a webserver
(Running Server 2003). We have set the ASP.NET permissions on the
appropriate folders. We have set the application to usesRemote = True.

It loads the database ok, once we set usesRemote = True but it cannot
load the queries from this database.

Any insights or things to check?

Cheers
Andy

[Cowboy (Gregory A. Beamer) - MVP]

Possible clue:
Where is the database located? In a subfolder of the webroot or outside?

In Windows Server 2003, the location of the physical file counts, as
transversing up the folder tree is prohibited by default. In addition, you
have to ensure that Network Service has access to the file, as it is the
account that IIS runs under in 2003.

Be careful reducing privledges to get at the data. You could end up with an
unnecessary security hole. Consider placing the database on a server other
than the web server and adding a web service interface to get at the data
(either ASMX or Remoting). This allows you to reduce security on the database
without opening it to the world.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***************************
Think Outside the Box!
***************************
"Andy" wrote:

We have an ASP.NET application exported from MS Access 2003.
I uses a series of queries to generate a page showing todays bookings.

It works locally but does not work when we put it on a webserver
(Running Server 2003). We have set the ASP.NET permissions on the
appropriate folders. We have set the application to usesRemote = True.

It loads the database ok, once we set usesRemote = True but it cannot
load the queries from this database.

Any insights or things to check?

Cheers
Andy