Do you have some kind of exaple of a tiered design for me to look at?
Thanks!
>>Is there any commands or methods to get exclusive control of a table that is being shared on a network to issue a pack command without closing down the applcation network wide?
>>
>>TIA
>
>It is a complex issue but the short answer is No, you can't open a table exclusively when someone else is using it. I'm sure I've seen 1001 ways to approach this but it boils down to designing your app to keep a record of who is using what so you can either issue warnings or use that information to schedule maintenance. IMO, if you are faced with this situation it may be time to think about upgrading to a tiered design rather than having clients "USEing" tables across the network.
Jeff Pearce