CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2
  1. August 11th, 1999, 07:11 AM #1
    muralirajan
    muralirajan is offline Junior Member
    Join Date
    Aug 1999
    Posts
    16

    Comparison of MS SQL server with MS Access for using as back end.


    What are the advantages of using MS SQL server over MS Access for using as a back end?
    Can you please send som cases where only MS SQL can be used and not MS Access?


    muralirajan
    Reply With Quote Reply With Quote
  2. August 11th, 1999, 01:46 PM #2
    johnk
    johnk is offline Junior Member
    Join Date
    Aug 1999
    Location
    SC, USA
    Posts
    22

    Re: Comparison of MS SQL server with MS Access for using as back end.

    From a managers point of view, we experienced data locking contention with Access. No such problem with SQL Server. Access does page locking, SQL Server 7 can do row locking.

    From an application structural view, we found significant performance benefits from using disconnected recordsets with SQL Server.

    Hope this helps

    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules




Click Here to Expand Forum to Full Width

Featured