CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums
Results 1 to 3 of 3

Thread: Strength of MSAccess 2007.

  1. #1
    Join Date
    Sep 2008

    Question Strength of MSAccess 2007.

    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?


  2. #2
    Join Date
    Apr 2002

    Re: Strength of MSAccess 2007.

    I don't recommend ms access for such application. It's not good under high concurrency.
    I suggest using MS Sql server express edition. It's free and you can upgrade to a standard or enterprise easily.
    Hesham A. Amin
    My blog , Articles

    <a rel=" border="0" /> @HeshamAmin

  3. #3
    Join Date
    Sep 2008

    Talking Re: Strength of MSAccess 2007.

    Thanks to you. I opted for MS SQL Express.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Windows Mobile Development Center

Click Here to Expand Forum to Full Width

On-Demand Webinars (sponsored)