The VB6 runtime are about 1Mb.. not that big...
Well if you have experience in Access, it's not like you have to start all over again.. just a little :-)
I think it's worth it, VB is more flexible then Access.