Syntax error in FROM clause.
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
|