To Dataminer: How do you organize your database?

[BluEsiNsOuL]

My database is just a little bit over 300,000 hands. Yesterday after an overnight datamine it starts to get some error and can't input hands history anymore. My database is still in ACCESS mode, about 2G. Weird isn't it? I read somewhere else that 2G database should contain 400,000 hands. Anyways, the limit is approaching. I tried to convert it to SQL format but it failed due to some error.

My question is, how to manage your database? I understand that even if you convert the format to SQL format eventually you will need to start a new one because of the speed problem. If I start seperate database, should I seperate them by the limit or just automatically open a new one after reaching the limit? How does that affect the efficiency of the HUD like PokerAce?

Thanks.