>>
>>But... what happens to open tables? Do they remain open through the disconnect/connect of network resources?
>>
>>Thanks for dragging me outside the box - my thinking was too limited and based upon old realities.
>
>If the files that were open were on the server, they would no longer be open when the server comes back up. This does not seem like a good thing to happen to your files -- abnormally being closed when server goes down. If these files existed on your workstation, they would remain open. Unfortunately, the only thing that would happen is the re-establishment of your connection, not the re-opening of files on the server. You could also test for this in your application and re-open if necessary. Very easy to do.

I thought that might be the case. Easiest thing for me to do upon detecting network failure is wait until it's back up, then executing a new instance of my program and terminating the current one.

Thanks.