Setting dbprefix for one Model

[eluser]Ben Bowler[/eluser]
I have two Codeigniter applications running from one database. Each has a different dbprefix but share a users table.

I've tried resetting the prefix with this:

Code:

$this->db->set_dbprefix('newprefix');

However when called in a Model it is applied to all future queries. Do I have to re declare the prefix for each model or is there a way to do it by editing the core db library?

Any ideas would be much appreciated. I'll update here as I go.