Simple DB query

Going nuts here, and can't figure out why I keep getting:

Microsoft VBScript runtime error '800a01a8'

Object required: ''

From this pretty straight forward query:

        strSQL = "SELECT " & strDbTable & "Configuration.Cam " & _
        "FROM " & strDbTable & "Configuration" &  strDBNoLock & " " & _
        "WHERE " & strDbTable & "Configuration.ID = 1;"
       
   
        'Query the database
        rsCommon.Open strSQL, adoCon


The table exists. Is there something else I'm missing that could be the problem? Thanks much for the help.

Thanks for your help.