Results 1 to 6 of 6
  1. #1
    Join Date
    Feb 2004
    Posts
    3

    Unanswered: Access Vs SQL Server

    Hello!

    I am trying to gather information on why MS SQL Server 2000 is a better enterprise level database management system MS Access 2002. There is an article on the Microsoft Technet, but when I try and access the article I get a 404 error. Link is there, but page behind is missing.

    http://www.micrsoft.com/sql/techinfo.../SQLAccess.asp

    I know the basics, just want stats and facts to back them up.

    Thanks...

  2. #2
    Join Date
    Feb 2004
    Location
    Rhode Island
    Posts
    69

    Re: Access Vs SQL Server

    Originally posted by swestenhofer
    Hello!

    I am trying to gather information on why MS SQL Server 2000 is a better enterprise level database management system MS Access 2002. There is an article on the Microsoft Technet, but when I try and access the article I get a 404 error. Link is there, but page behind is missing.

    http://www.micrsoft.com/sql/techinfo.../SQLAccess.asp

    I know the basics, just want stats and facts to back them up.

    Thanks...
    1) Volume of data
    2) Scalbility
    3) Performance
    4) OLAP
    5) Security features
    6) Easy Query processing
    7) Data distribution and replication
    8) Job scheduling
    9) Programmability

    There are lots of reasons like this. Access is good if your data is less than 2GB and depends what you are looking from a database.

  3. #3
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Access is not a database "Server". Thus, if you have a query in Access that joins a parent table with 10,000 rows to a child table with 100,000 to return a filtered set of records consisting of, say 200 rows, Access will transfer all 110,000 records from both tables over your network and then perform the SQL statement on whatever (slow) desktop the user happens to be at.

    Under SQL Server, all the calculation is done on the (powerfull quad-processor, RAM out the wazzoo) server, and only the final 200 rows are returned over your network.

    In a nutshell, running Access as an Enterprise solution drags a network to its knees.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  4. #4
    Join Date
    Feb 2004
    Posts
    3
    Originally posted by blindman
    Access is not a database "Server". Thus, if you have a query in Access that joins a parent table with 10,000 rows to a child table with 100,000 to return a filtered set of records consisting of, say 200 rows, Access will transfer all 110,000 records from both tables over your network and then perform the SQL statement on whatever (slow) desktop the user happens to be at.

    Under SQL Server, all the calculation is done on the (powerfull quad-processor, RAM out the wazzoo) server, and only the final 200 rows are returned over your network.

    In a nutshell, running Access as an Enterprise solution drags a network to its knees.
    Thanks all!! This should be good fuel for my client to use... thanks for the help!

  5. #5
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Hey...no one told him about the cost....

    What's the differences between a kia and a bentley?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  6. #6
    Join Date
    Feb 2004
    Posts
    3
    Originally posted by Brett Kaiser
    Hey...no one told him about the cost....

    What's the differences between a kia and a bentley?
    I know the cost differences involved, and the client is aware as well, and in the long run, user connection timeouts and database size limitations may outway the costs based on recovery and migration...

    Thanks again!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •