[AccessD] ASP and Access Problem

Okay, am I to understand that the Access FE is working fine, but the ASP FE
is having problems?

First of all, is anyone going into the BE directly?  That could be an easy
problem to fix.  If the BE is being locked, no one is going to be working.

Next, is the BE located on the IIS machine, or it on a network resource?  If
it's on a network resource, that can also be an issue, depending on how the
security of the IIS machine is setup.

Drew
-----Original Message-----
From: Jim Hewson [mailto:JHewson at karta.com]
Sent: Tuesday, March 04, 2003 3:20 PM
To: 'accessd at databaseadvisors.com'
Subject: [AccessD] ASP and Access Problem



I'm lost as usual with this problem.

An Access 2000 BE with ASP and MDE FEs.
The MDE works well at our site with the BE.  The ASP FE works well on our
test site.
When we put the files on the client's server, they constantly get the
following error.
HTTP 500 - Internal server error 
Internet Explorer 
Here is what I know:
Developed in Access 2000, they use Access XP (shouldn't make a difference)
Two people use the MDE at the main office through a network.  Both computers
use WinXP, one has problems with the FE in reference to Mid function not
available.
Both computers have upgraded to MDAC 2.7, have the latest service pack for
Windows, Office and Access. The configuration for the computers seem to be
the same.
There are 50+ sites that use the web site for data entry.  About 3/4 of
those have been able to use the site successfully with some having
intermittent problems with accessing it.  Others have not been able to
access it at all.

When we started this project, their network was extremely slow (3-4 seconds
to show a network drive) in their office.  Since then they have upgraded the
server, changed network companies and now are in the process of changing
their ISP (they were using a DSL).

What could be the problems?


Jim
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com