CPU1 is my server/workstation and CPU2 is just a workstation. They both run
the same software but CPU2 accesses the database from CPU1. There is a delay
when accessing the DB from CPU1. What can I do to speed up the speed that it
accesses the db?

On Fri, 13 Feb 2009 08:56:28 -0800, MC Hammer <MC
Ham***@discussions.microsoft.com> wrote:

It's largely a matter of where the processing gets done. With a
desktop database like Access the processing is all front end so huge
amounts of data may have to travel across the network for just a
simple query. With a proper database like SQL Server the majority of
the processing will be done by the server so the amount of data
needing to traverse the network will be much less.

Perhaps you can look at using some sort of remote access software.
Remote desktop, VNC or the like.


Jim.

How do wired and wireless connections to a home router work?
Where do I find WPA2-PSK AES on WinXP SP3
Want to add wireless to existing lan
How do you tell Windows XP Pro to connect to a wireless that isn't broadcasting SSID?
Wireless DSL Connection Dilemma
Network key
WiFi Connection Delivered To Ethernet Port?
Add a stand-alone printer with print-server to Guest WLAN?
adding printer to home network
media state........................media disconnected