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
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
