By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,486 Members | 2,061 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,486 IT Pros & Developers. It's quick & easy.

Strength of MSAccess 2007.

P: 79
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
Mar 6 '10 #1

✓ answered by NeoPa

Check out Converting to Access 2007 for the Access 2007 info. I expect you'll find all you need there, or from there.

As far as MSSQL goes, I believe there is a readily downloadable Express version of SQL 2008 available. I'm not sure exactly what the limitations are, but I expect it would be adequate for your requirements. Don't forget to scroll down and select just the version you require.

Share this Question
Share on Google+
1 Reply


NeoPa
Expert Mod 15k+
P: 31,186
Check out Converting to Access 2007 for the Access 2007 info. I expect you'll find all you need there, or from there.

As far as MSSQL goes, I believe there is a readily downloadable Express version of SQL 2008 available. I'm not sure exactly what the limitations are, but I expect it would be adequate for your requirements. Don't forget to scroll down and select just the version you require.
Mar 7 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.