Strength of MSAccess 2007.

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

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Michael Sheley16y ago
I have used 2003/2007 for years as a back end with up to 50 users without any issues.
Two Gig in size, two billion or so records.
The reason I use it is because of the reports. Much cheaper for the client instead of SQL Server and Crystal, for example.