I have run into an issue with MS Access that I never encountered with MySQL.  When I try to get the count of records for a data set, no value is being returned.  Below is my code for my MS Access table.  Note in the comment sections I have included what I see in my Trace output....

The LastQuery statement works just fine in Access so I don't think that is it.  Am I missing something easy here....  Thanks for the help.....

Code:

        Dim ad As AddressDirectory = New AddressDirectory

        ad.Query.es.CountAll = True
        ad.Query.es.CountAllAlias = "Count"

        If (ad.Query.Load()) Then
            Page.Trace.Write(additem.Query.es.LastQuery)
            ' Trace Prints >> "SELECT Count(*) AS "Count" FROM [AddressDirectory]"

           EsDataSourceAddressDirectory.TotalRowCount = CInt(ad.GetColumn("Count"))
            Page.Trace.Write("Total Count: " & ad.GetColumn("Count"))
            ' Trace prints >> "Total Count: "	

        End If

For Access we were using the string delimiters ("Alias") for the CountAllAlias rather than the Column delimiters ([Alias]). It produce valid syntax as your LastQuery shows, but the column name includes the double-quotes. That is being fixed in ES2008.

EsDataSourceAddressDirectory.TotalRowCount = CInt(ad.GetColumn("""Count"""))
Page.Trace.Write("Total Count: " & ad.GetColumn("""Count""").ToString())