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.