Codeigniter limit on Access database
===

I have the following "Active Record" setup:

    $this->db->select('*');
    $this->db->from('Orders');
    $this->db->join('MPC_Agents', 'Orders.UserName = MPC_Agents.UserName', 'inner');	
    $this->db->limit(50,20);
    $query = $this->db->get();

Using `$this->db->last_query();` mereley outputs:

    SELECT * FROM (Orders) INNER JOIN MPC_Agents ON Orders.UserName = MPC_Agents.UserName

Why won't it apply the limit?

