Solved

advantages of SQL over Access

Posted on 1998-07-21
3
23,655 Views
Last Modified: 2012-06-22
I'm looking for advantages that SQL Server has over MS Access. Mainly, what are the reasons that an SQL server is a better way to store and run databases from, rather than MS Access. Also, if you know of a detailed web site that contains this information please let me know. Thanks a lot.
0
Comment
Question by:mpopal
3 Comments
 
LVL 3

Author Comment

by:mpopal
ID: 1976970
Adjusted points to 200
0
 
LVL 9

Accepted Solution

by:
perove earned 200 total points
ID: 1976971
There are three advatages that I see.
1.High user Load:Jet handels 20 30 concurent users quite well, but more that that = prefomace going down.
2.Remote connections:The server does the hard work of slecting records to return therefor over a LAN or a WAN a SQlserver provide a much better preformance than JET
3.Tightly controlled data:Sqlserver har a better model than Jet for securety transact. control and also of backup & recovery.

Links for this discussion and other SQL server/Access are :
http://www.wji.com/access/w8710.html
http://www.microsoft.com/accessdev/articles/autwp.htm
http://www.microsoft.com/accessdev/articles/av9709.htm
perove

0
 
LVL 12

Expert Comment

by:Trygve
ID: 1976972
Comment to point no. 2 from Per Ove

The reason for the increase is not just the fact the server is doing the selecion. If Access is to do the selection all records from the tables involved in a query has to be sent to the local computer. Example: Select one user from a user table with 10000 records. SQL Server sends one record over the LAN/WAN. Using the MDB variant, the computer will retrieve all 10000 records from the MDB file and the process it locally. So in addition to the spead increase from the more powerfull processor on the server you also get enormous savings in network traffic with corresponding increase in spead.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question