SQL Query Failing

[Ken D.]

I have developed a database application in VB6 that is using ADO 2.5 to connect
to an Access 2000 database (Jet 4.0). The application is running fine off
of Windows 2000 systems; however, I've run into problems when running the
app off of Windows NT. When a SQL query is run, the recordset does not return
all of the records. The SQL is as follows:

SELECT qryMatch_All_REVISED.txtBU, qryMatch_All_REVISED.Name_Rpt, Sum(qryMatch_All_REVISED.Variance)
AS SumOfVariance, qryMatch_All_REVISED.Period
From qryMatch_All_REVISED
GROUP BY qryMatch_All_REVISED.txtBU, qryMatch_All_REVISED.Name_Rpt, qryMatch_All_Revised.Period

Having (((qryMatch_All_REVISED.Period) = varPeriod
ORDER BY qryMatch_All_REVISED.txtBU, qryMatch_All_REVISED.Name_Rpt

The SQL is running off of a union query stored in the Jet db.

We reinstalled MDAC 2.7 with all of the patches on the NT system, but still
are not getting the correct results.

Are some significant differences between Windows 2000 and NT that I am missing?
Maybe my setup file is missing a DLL or 2 that is on the Windows 2000 machines
but no the NT machine? Any advice or ideas would be greatly apperciated.
Thank you.

Ken

[Bernie]

"Ken D." <kenneth.dowd@arvinmeritor.com> wrote:
>
>I have developed a database application in VB6 that is using ADO 2.5 to
connect
>to an Access 2000 database (Jet 4.0). The application is running fine off
>of Windows 2000 systems; however, I've run into problems when running the
>app off of Windows NT. When a SQL query is run, the recordset does not
return
>all of the records. The SQL is as follows:
>
>SELECT qryMatch_All_REVISED.txtBU, qryMatch_All_REVISED.Name_Rpt, Sum(qryMatch_All_REVISED.Variance)
>AS SumOfVariance, qryMatch_All_REVISED.Period
>From qryMatch_All_REVISED
>GROUP BY qryMatch_All_REVISED.txtBU, qryMatch_All_REVISED.Name_Rpt, qryMatch_All_Revised.Period
>
>Having (((qryMatch_All_REVISED.Period) = varPeriod
>ORDER BY qryMatch_All_REVISED.txtBU, qryMatch_All_REVISED.Name_Rpt
>
>The SQL is running off of a union query stored in the Jet db.
>
>We reinstalled MDAC 2.7 with all of the patches on the NT system, but still
>are not getting the correct results.
>
>Are some significant differences between Windows 2000 and NT that I am missing?
> Maybe my setup file is missing a DLL or 2 that is on the Windows 2000 machines
>but no the NT machine? Any advice or ideas would be greatly apperciated.
> Thank you.
>
>Ken
>
Hi Ken,

Before doing anything else, try to enclose all fieldnames with square brackets
like [qryMatch_All_REVISED].[txtBU]

I have found out that some names seem to be restricted, e.g. authority, password
and some more. But it seems to be inconsistent between OS versions...

Bernie