Why do u go for SQL Server instead of Access

hi all,

Why do u go for SQL Server instead of Access.

any1 suggest..
kandan

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é

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