SQL Server or ACCESS?

  • Thread starter Thread starter HKSHK
  • Start date Start date
H

HKSHK

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
 
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/prodinfo/sysreqs/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
 
Think about Access Projects. You get tge front end ease of access with the
backend power of sql. they work well together.
Jack
 
Back
Top