Connecting Tech Pros Worldwide Help | Site Map

STDEVP problem?

Phil Jenkins
Guest
 
Posts: n/a
#1: Feb 16 '06
Hopefully someone can help with this one...

We're including a STDEVP function in a query sent to a local Access DB
from a C# Application - with an OleDataAdapter. We're using Jet 4.0 OLE
Drivers - and have no problems on any machines with Access (or the
Access runtime) installed.

One user - who does not have any version of Access installed - is
having trouble with this particular query (i.e all the queries in the
application return a set of results for a graph - and the one with
STDEVP doesn't). They are running Windows 2K SP4. I have tried the
application on a clean Windows 2K3 Server and XP box with no problems.

Am I right in thinking it's somehow this Jet-specfic function that is
causing the query to return incorrect (i.e. null) values? I'm confused
as to exactly what needs to be installed for this function to work
correctly - and if it isn't working correctly, why no errors are being
encountered.

Many thanks

Phil Jenkins

Closed Thread


Similar Microsoft Access / VBA bytes