It works with the first code that you gave me. If I try the open using strSQL instead of the table name in quotes, I get the following error:
ADODB.Recordset error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another...