I am running the following code:
Dim MDBInfoCMD As ADODB.Command
Dim lngInfoCnt As Integer
VSGSAMDB is active conection
strSAMTotCntSql declared

Set VGInfoTable = New ADODB.Recordset
Set MDBInfoCMD = New ADODB.Command
Set MDBInfoCMD.ActiveConnection = VSGSAMDB

MDBInfoCMD.CommandText = strSAMTotCntSql
strSAMTotCntSql = "SELECT Count([MDB Information].converted) AS Cnt FROM [MDB Information];"

VGInfoTable.Open strSAMTotCntSql, VSGSAMDB, adOpenKeyset, adLockOptimistic, adCmdTable

Having no issues at all to run this within the database, but in VB6 code i am getting the following error:
?err.Description
Syntax error in FROM clause.
?err.Number
-2147217900

SELECT COUNT(*) AS CNT FROM tablename WHERE fieldname = criteria...

(*) could be field name that has an index (to make it faster, where clause is optional...

SELECT COUNT(fieldname) AS CNT FROM tablename



Good Luck