Results 1 to 3 of 3

Thread: Why do u go for SQL Server instead of Access

  1. Nov 30th, 1999, 03:54 PM #1
    kandan
    kandan is offline

    Thread Starter
    Member
    Join Date
    Aug 1999
    Posts
    52

    Post

    hi all,

    Why do u go for SQL Server instead of Access.

    any1 suggest..
    kandan

    Reply With Quote Reply With Quote
  2. Nov 30th, 1999, 05:20 PM #2
    André
    André is offline
    Addicted Member
    Join Date
    Jun 1999
    Location
    Los Angeles
    Posts
    186

    Post

    Sql server is much bigger:
    Security,
    Scalation,
    Size of data (fx videoclips)
    DTC, distributed transaction coordinator

    Access i guess is more for a PC solution.
    For an enterprise solution access is no match for SQL-Server.

    regards
    André
    Reply With Quote Reply With Quote
  3. Nov 30th, 1999, 08:25 PM #3
    Serge
    Serge is offline
    Serge's Avatar
    Join Date
    Feb 1999
    Location
    Scottsdale, Arizona, USA
    Posts
    2,744

    Post

    The main difference between SQL Server and Access is:

    Access - is a personal database, even if the database itself is on the network

    SQL Server - is a Client/Server database.

    Why Access is personal even though you have database on the network: because you computer still has the database engine installed locally, which drives the data, where SQL Server's engine is on the server.

    ------------------

    Serge

    Software Developer
    [email protected]
    [email protected]
    ICQ#: 51055819

    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width