[AccessD] OT Access Traffic Query

A couple of points (3 actually)

1. Even if you split it, the processing will still all take place on the
desktop.  The primary benefits of splitting have to do compressibility and
version control.
2. It is a good idea to split it anyway, and not that tough.
3. Even if you use SQL or MSDE, it is still pretty easy to mess it up so
that the processing takes place on the desktop.

Regards,

Steve Goodhall


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Stuart
McLachlan
Sent: Thursday, November 06, 2003 8:28 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] OT Access Traffic Query


On 6 Nov 2003 at 13:24, paul.hartland at fsmail.net wrote:

> To all, We have a Win2000 Server network with Office XP Professional
> using Access XP, we don't have a front-end or back-end to this system
> (I inherited it, lucky me).  So everyone has a shortcut to the .mdb on
> the Server, when a query is run on the .mdb is it the Server that will
> do the processing or the desktop unit of the user ? Anybody know how it
> actually works, cause I may have to modify the Aplication. Paul

The  desktop does all the processing.

It is behaving exactly it would if the application was on a local
disk (only it takes longer to pull everything over the network than
it would from a local drive).
--
Lexacorp Ltd
http://www.lexacorp.com.pg
Information Technology Consultancy, Software Development,System
Support.



_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com