MS Excel database using visual basic VS. MS Access database

By g_guce ·

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.


This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums