johnwood
asked on
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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.