Database Management

posted by .

What is wrong with using MS Access for a fifty station online purchasing system or though rare, when might it be OK. What is wrong with using SQL Server for a "Mom and Pop" shop of three computers?

  • Database Management -

    MS access is great when there is little traffic. Its minimal maintenance costs makes it perfect for that situation. It just does not handle many simultaneous queries.

    On the other hand, SQL server is designed for high volume traffic, and it is supposed to be scalable, i.e. handle large volumes with appropriate increase in resources. There is nothing wrong with using SQL server for a minimal setup, as long as the substantial start-up cost and administration cost is not a burden to the administrator.

Respond to this Question

First Name
School Subject
Your Answer

Similar Questions

  1. windows 2003 server

    You are the network administrator for an electrical goods importer in Brandon, FL. You have a single Windows Server 2003 system that is a domain controller, a DHCP and DNS server, a file and print server, and the company e-mail server. …
  2. window 2003 server

    You are the network administrator for a telecommunications company in Rochester, New York. The network consists of two Windows Server 2003 systems and 57 Windows XP Professional systems. Both servers are used as domain controllers. …
  3. math

    customer arrive at a two server system at poisson rate 3 per hour.an arrival finding the system empty is equally likely to enter service with either server.an arrival finding one cusomer in the system will enter service with the idele …
  4. Database Management

    your projects should contain the following: 1. write a prosa text for a domain of your own (maximum 1 A4 sheet of paper) 2. model this text in form of an EER diagram or UML class diagram 3. create a SQL script for building all tables …
  5. Networking

    Jack is setting up a new FTP server that is running the Windows XP operating system. This FTP server will be shared by seven different corporate departments, each identified by a user group, but access is to be restricted by department. …
  6. 9th math algebra

    The stars indicate the answers i think are correct. 1. What number is a solution of the inequality?
  7. dynamic Decision making

    Using the concepts that you learned from the online explanation of control theory, describe the operation of a Subway sandwich shop. Be sure to describe the system using feedback loops and a detailed narrative.
  8. management information system

    hi theres a bunch of wrong answers in my quiz earlier and i want to know the correct answer, so please help, and this not not my homework..thanks 1.amount of time and attention required is a typical___measure of product performance …
  9. SQL server help!

    A SQL statement is needed to create a stored procedure, which adds a new record to the Part table of week 3. The stored proc returns an out parameter that contains the value of the PartID PK of the record just added. Input parameters …
  10. buissness

    Data Security Password protect the database you created for your individual assignment in Week Three. Create a matrix to indicate the permissions (read, insert, delete, modify) you would grant to different users of your database. Create …

More Similar Questions