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

Thread: Strength of MSAccess 2007.

Hybrid View

  1. #1
    Join Date
    Sep 2008
    Posts
    79

    Question 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

  2. #2
    Join Date
    Apr 2002
    Location
    Egypt
    Posts
    2,210

    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=https://twitter.com/HeshamAmin" border="0" /> @HeshamAmin

  3. #3
    Join Date
    Sep 2008
    Posts
    79

    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)