Why do u go for SQL Server instead of Access

[kandan]

hi all,

Why do u go for SQL Server instead of Access.

any1 suggest..
kandan

[André]

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é

[Serge]

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
Serge_Dymkov@vertexinc.com
Access8484@aol.com
ICQ#: 51055819 (http://www.icq.com/51055819)