I am currently designing a database program in VB 6.0 SP4 Enterprise edition. I am using ADO 2.5 for my Access database. My question is, I hope, very simple.

I am going to have a single user and a multi-user version of this program. For the multi-user, do I use SQL Server to host the .mdb files? I plan on having anywhere from 2-15 users on the system at the same time. There probably will be around 8-10 different .mdb files when I am finished.

Also, how much do the server programs that you recommend cost?

Thanks,

Eric