Solved

advantages of SQL over Access

Posted on 1998-07-21
3
23,681 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

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

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

627 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