[RESOLVED] How to choose database

[AlphaOne]

I am in the planning process of a hotel booking system and have some questions about database to use.

What will be the best database to use. There will be a multi-user environment of maybe 5 to 10 users. I guess SQL server is out due to the price. How about ms access? Or SqlExpress?

We do not want a database that we need to pay for so access is a good choice. If we got it correct do we need to install SqlExpress in all computers that is running the software, Correct? Or is it ok to just install it on the computer that is having the database, Or?

Please help us to guide us in to the right direction.

Bert

[jmcilhinney]

I would probably avoid Access for that number of concurrent users. SQL Server Express is a good option because it provides a simple upgrade path to SQL Server down the track. There's also MySQL, which is as powerful as SQL Server, and Oracle offer a free Xpress Edition too. SQL Server is probably easiest due to the integration with VS. SQL Server Express is a server, just like its big brother. You install it on one machine and then connect from wherever.