There are several editions of SQL Server, some of them free (MSDE, SQL
Server 2005 Express, etc.). Access works fine for small groups and
standalone applications, but SQL Server scales better and it is a much
better database.
About requirements, see:
http://www.microsoft.com/sql/prodinf...s/default.mspx
About SQL, SQL Server uses T-SQL and Access uses Jet-SQL. However, both of
them understand ANSI SQL (for the most part), and depending on your access
method (.NET, ODBC, OLEDB) they can understand ODBC syntax such as { oj ...}
for outer joins or { fn ...} for functions.
--
Best regards,
Carlos J. Quintero
MZ-Tools: Productivity add-ins for Visual Studio
You can code, design and document much faster:
http://www.mztools.com
"HKSHK" <hk***@gmx.net> escribió en el mensaje
news:11*********************@i40g2000cwc.googlegro ups.com...
Hi guys,
I am still struggling which database I should use... A friend of mine
suggested that I should use SQL Server rather than Access. Now I
wonder...
a) Which database offers the better speed?
b) How are the requirements if I want to use a SQL Server db (min. RAM,
min. free hard disk space)?
c) Are there differences in the SQL language between SQL Server and
ACCESS?
Thanks in advance for your help!
Best Regards,
HKSHK