Solved

advantages of SQL over Access

Posted on 1998-07-21
3
23,633 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

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
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…

759 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now