This may help...

Code:
rs.open "SELECT * FROM TableName", adoConn, adOpenKeyset, adLockOptimistic, adCmdTable