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

 

[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

 

[Cerebrus]

Hi,

The answer depends on your needs.

Check out this post :

http://groups.google.com/group/micr...ges.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.

 

[Guest]

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