I cannot remember exactly. But here are some points you may check.
1. Open your connection or recordset in client side;
2. After your strSQL in the OPEN statement, add another switch. You will have options after hitting the key ",".
Hepefully, they help.