Question Strength of MSAccess 2007.

[priyamtheone]

Hi,
I have a few questions. First of all, what's the flexibility and strength of MSAccess 2007 and how much data and transactions can it support?

Second, I would like to know whether it's optimum to use MSAccess 2007 as database for a small banking system, provided it's a real life application and not a demo/tutorial one. The system will have approximately 250-300
customers per year and their daily transactions for the whole year that'll count upto 1,10,000.
If MSAccess isn't optimum then which light version DBMS can I use? How about MySQL or something else?

Third, is there any light version for MSSQL server that fits into my scenario, for almost all the MSSQL versions I have seen are developer/enterprise editions?

Regards
Priyamtheone

 

[mikemc]

Based on your specifications you should not use Microsoft Access 2007. It's limited to 2 GB of data, is not multi-user (though it can be used for 4-10 users in some scenarios), and is not very securable.

Microsoft SQL Server Express is the light version of MS Sql Server an its free. See it at -> Sql Server Express

Assuming you are building a web application it will work well with the volume of customers and transactions your expect.

 

[Tom]

Sql Server is definitely the better choice.

 

[JuggaloBrotha]

While Access databases are extremely portable (don't need a dedicated server) they lack security. Given this is for a banking system, security should be much higher than what Access can offer.

 

[priyamtheone]

Thanks to you all. I opted for MS SQL Express.