Access vb SQL Server

Hi,

This is not a homework.

A book states that the main advantage of SQL Server is that the SQL statements are processed on the server. Can Access do the similar job?

johnwoodAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
rspahitzConnect With a Mentor Commented:
You can point to an Access database on the server.

From my perspective, the main advantages of SQL*Server is that it will always be on a server which is dedicated to supporting a full-fledged database.  It offers tools to assist in the effort of maintaining a database while many users are connecting to it.  It was intended to work with hundreds (or thousands) of simultaneous users.

Access takes less administration, less space, and is easier to implement for small projects.
0
 
mullerceCommented:
Access is a client/server system. The client consists of the forms and reports running in Access.

The database server is usually the JET database engine that is installed on your workstation as the default when you install Access. There is an optional database server called the MSDE that is also included on the Access 2000+ or Office 2000+ CDROM. Both of these Access database servers (engines) run on the same machine as the Access client.

Access can also connect to other servers accross the network. In the case of remote network servers, most of the data processing is done on the server, unlike the Access database engines where it is all done on the workstation.
0
 
Éric MoreauSenior .Net ConsultantCommented:
If you want some work to be done on the server when you are using Access, you will need to run some components (ActiveX DLL or ActiveX EXE) via DCOM.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.