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

[muralirajan]

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

[johnk]

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