SQL Server or ACCESS?

1 Mar 2006 1:50 PM

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

1 Mar 2006 2:27 PM

Carlos J. Quintero [VB MVP]

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

Show quoteHide quote

"HKSHK" <hk***@gmx.net> escribió en el mensaje
news:1141221013.291053.83090@i40g2000cwc.googlegroups.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
>

1 Mar 2006 9:05 PM

Yellow Legal Pad

Think about Access Projects. You get tge front end ease of access with the
backend power of sql. they work well together.
Jack

Show quoteHide quote

"Carlos J. Quintero [VB MVP]" wrote:

> 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
>
>
> "HKSHK" <hk***@gmx.net> escribiÃ³ en el mensaje
> news:1141221013.291053.83090@i40g2000cwc.googlegroups.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
> >
>
>
>

1 Mar 2006 2:28 PM

Cerebrus

Hi,

The answer depends on your needs.

Check out this post :

http://groups.google.com/group/microsoft.public.dotnet.languages.vb/browse_thread/thread/7b080b9035750344/

2. SQL Server comes in various editions (again depending on your
requirement), and each has different System Requirements. Check out :

http://www.microsoft.com/sql/prodinfo/sysreqs/default.mspx

3. SQL Server uses Transact-SQL, which IMO is more powerful.

Regards,

Cerebrus.