What is the best choice of database for multiple user access on an FTP site?
Posted on 2011-02-26
I want to develop a simple company database to keep track of contacts, communications, bugs, etc., that is accessible by all of our employees. I will write a "front-end" in VB.NET 2010 to link to this database, and I will install it on everyone's system (there are only a few of us), but I need to have the database accessible to everyone, and it is likely that there will be times where more than one of us will be connected to it at the same time. We have an FTP site so, ideally, I would like to upload the database there, unless there is a good reason not to.
So my questions are:
1. What database should I use? I currently work with MS Access, so I would be very happy if that could work. I also prefer using Access since then I don't have to worry about installing a server on the client's system. However, the little research I have done suggests that Access on an FTP won't work well. Is that true, or is there a way I can use Access in this case? Or, if not, what database would you recommend?
2. With whatever database is recommended, how do I make a connection to it on an FTP server?
Thank you very much,