Solved

Access vb SQL Server

Posted on 2001-09-14
3
124 Views
Last Modified: 2012-05-04
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?

0
Comment
Question by:johnwood
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 22

Accepted Solution

by:
rspahitz earned 40 total points
ID: 6484105
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
 

Expert Comment

by:mullerce
ID: 6484389
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
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 6484998
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

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction While answering a recent question (http://www.experts-exchange.com/Q_27402310.html) in the VB classic zone, I wrote some VB code in the (Office) VBA environment, rather than fire up my older PC.  I didn't post completely correct code o…
Most everyone who has done any programming in VB6 knows that you can do something in code like Debug.Print MyVar and that when the program runs from the IDE, the value of MyVar will be displayed in the Immediate Window. Less well known is Debug.Asse…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question