SQL Server or ACCESS?

[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

[Cerebrus]

Re: SQL Server or ACCESS?

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/prodinf...s/default.mspx

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

Regards,

Cerebrus.

[Carlos J. Quintero [VB MVP]]

Re: SQL Server or ACCESS?

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" <hkshk@gmx.ne t> escribió en el mensaje
news:1141221013 .291053.83090@i 40g2000cwc.goog legroups.com...[color=blue]
> 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
>[/color]

[Yellow Legal Pad]

Re: SQL Server or ACCESS?

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

"Carlos J. Quintero [VB MVP]" wrote:
[color=blue]
> 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" <hkshk@gmx.ne t> escribió en el mensaje
> news:1141221013 .291053.83090@i 40g2000cwc.goog legroups.com...[color=green]
> > 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
> >[/color]
>
>
>[/color]