oops, sorry I didnt explain. 

create 2-3 databases, e.g. DatabaseA, DatabaseB & DatabaseC.

partition the required data into 3 tables splitting the data equally into DatabaseA, DatabaseB & DatabaseC.  Create a View in DatabaseA which contains the tables created in DatabaseA, DatabaseB & DatabaseC.  This should solve the 4Gigabyte limit, a bit messy to say the least....bill remove that 4Gigabyte limit !!!