I just finished a CRM software for the company I work
I just finished a CRM software for the company I work. The executable and
the db (in access) are located on a server, so each client (around 15) has a
shortcut to that executable.
My thought: is that configuration better than having the executable on the
client and just use the network path in the connection string? I mean that
in terms of execution speed, network traffic etc
I alway thought that file executed on client machine anyway.
Of course it is slower to upload file to client every time.
But from your point of view it is much more convinient to keep it online.
This way you replace it in 1 place if updated.
Execution time is the same, but start-up time (and network traffic) are
increased by having the program file on the server.
The best arrangement might be to have the program file on each PC and a copy on
the server. When the client program starts up, it can check whether the copy on
the server is newer. If so, it could copy it to the client and set up a
winstart batch file that will replace the file the next time the PC is booted
up. This avoids any interruption of the user's work flow and any interaction
with other Windows programs when the executable is replaced.
VB3 source code: http://thelabwiz.home.mindspring.com/vbsource.html
VB6 source code: http://thelabwiz.home.mindspring.com/vb6source.html
VB6 - MySQL how to: http://thelabwiz.home.mindspring.com/mysql.html
Fix the obvious to reply by email.