>All of the tables reside on the server as does the compiles .exe the workstations then are working from a shortcut and this is where the transfer is being done at the workstation to the server.
In the shortcut's properties did you specify the start directory?
If it's not broken, fix it until it is.
My Blog