Solved

Access vb SQL Server

Posted on 2001-09-14
3
120 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
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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

There are many ways to remove duplicate entries in an SQL or Access database. Most make you temporarily insert an ID field, make a temp table and copy data back and forth, and/or are slow. Here is an easy way in VB6 using ADO to remove duplicate row…
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…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

813 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now