We have a database creating and tracking work orders for sewer maintenance.
Most all is working fine. However, I ran into one snag. Without going to much into detail with all the operations, one portion includes importing data from a couple external DB's stored on a remote network server. Our network is relatively quick with all remote locations connected via optic fiber. Internally, everything is on a Gigabit switch.
There is a master form with a button that opens a second import form where you select the work order to import. While designing and testing this, I had copies of all data residing on my local machine. For testing purposes, the network drives where mapped to my machine simulating as they would be with the data on the server -- all works great. However, when I move all data to the server and remap accordingly, one part bombs. The data is not imported unless I code in a 10 second pause before the "Import" button is enabled. I do not need this pause when all data is being pulled directly
from my machine. The "pause" function resolves the problem but with
numerous imports, it's a bit annoying. Any suggestions on what I could possibly do to resolve would be greatly appreciated.
Thanks,
SKK
Most all is working fine. However, I ran into one snag. Without going to much into detail with all the operations, one portion includes importing data from a couple external DB's stored on a remote network server. Our network is relatively quick with all remote locations connected via optic fiber. Internally, everything is on a Gigabit switch.
There is a master form with a button that opens a second import form where you select the work order to import. While designing and testing this, I had copies of all data residing on my local machine. For testing purposes, the network drives where mapped to my machine simulating as they would be with the data on the server -- all works great. However, when I move all data to the server and remap accordingly, one part bombs. The data is not imported unless I code in a 10 second pause before the "Import" button is enabled. I do not need this pause when all data is being pulled directly
from my machine. The "pause" function resolves the problem but with
numerous imports, it's a bit annoying. Any suggestions on what I could possibly do to resolve would be greatly appreciated.
Thanks,
SKK
