none
Thanks The question is solved RRS feed

All replies

  • Hello,

    • MS-Access was not designed for a lot of users to read/edit/add/delete at any given time.
    • SQL-Server excels with many concurrent users to read/edit/add/delete
    • MS-Access is prone to corruption
    • SQL-Server is not prone to corruption.

    Then you need to consider the cost of either database. MS-Access is much cheaper than SQL-Server but consider the points above.

    Does this help or do you need more specifics? 


    Please remember to mark the replies as answers if they help and unmark them if they provide no help, this will help others who are looking for solutions to the same or similar problem. Contact via my Twitter (Karen Payne) or Facebook (Karen Payne) via my MSDN profile but will not answer coding question on either.
    VB Forums - moderator
    profile for Karen Payne on Stack Exchange, a network of free, community-driven Q&A sites

    • Proposed as answer by Fei HuModerator Wednesday, November 1, 2017 8:49 AM
    Monday, October 23, 2017 7:39 PM
    Moderator
  • Hello Franz,

    MS Access and Sql server both are written by Microsoft, which are relational database management systems.

    MS Access is a Rapid Application Development tool that allows you to quickly build forms and reports that are bound to relational data. It comes with a file-based database engine (Jet/ACE).

    while SQL Server takes a client/server model. This means that SQL Server requires a running service to provide access to the datastore. And SQL Server allows you to create triggers and stored procedures whereas Jet/ACE does not.

    There is a article about the significant differences between them.In my personal view, SQL Sever is a much more professional system than Access. Sql Server is a better choice for you.

    Sincerely,

    Neil Hu

    Note: This response contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; Therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Tuesday, October 24, 2017 7:36 AM
    Moderator
  • Thanks for answering my question, Thanks Very much
    Tuesday, October 24, 2017 4:09 PM
  • Thanks for answering my question, Thanks Very much
    Tuesday, October 24, 2017 4:09 PM
  • Hello Franz,

    If you have got help with the replies, you could close the thread by marking as answer, This can be beneficial to other community members reading this thread.

    Sincerely,

    Neil Hu


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Sunday, October 29, 2017 5:52 AM
    Moderator