I am the programming manager of a small all-around computer store and we have been using MS Access for a couple of years for quick and easy (and cheap) applications. We have recently moved to Delphi and are wondering what is the best Database provider to use. I have already written some ADO stuff to connect to an Access database, but I'd like to get completely away from Access if possible. I'd love to use Interbase but it's too expensive for our clients. I'd love to use the BDE but I'd like to have a much smaller footprint.
I'll go ahead and list some of my wants and you can correct me if it's not possible.
- Something a little heavier than Access with an actual Client/Server model so that heavier tasks can be done on the server.
- Royalty free distribution (most of our clients are small businesses that are stretching their budgets just to write a custom program, let alone pay for a SQL server)
- Must be good in a multiuser environment (unlike Access)
- Built in security is a plus
I'm sorry if this is a topic that is discussed over and over, but I couldn't find much in the search so if you know of another topic that covers this same topic please let me know.