MS Excel database using visual basic VS. MS Access database

Hi,

I've been working on a monitoring database using MS Excel and I have a problem on its file size. I was able to compact it by saving it in .xlms format since its running on VB macros but its still quite large. I am thinking if I could redo the whole program in MS Access but I'm not certain if I would be able to achieve the ideal file size that I want (less than 1 MB). The program is being shared over the network with several users and also linked to other MS Excel files.

Any suggestions is highly appreciated.

Thanks!