>I have a public variable that I use to store my connection handle for SQL Passthrough. The variable is used in a number of forms, and was working fine until I came to a form that is telling me "Connection Handle is invalid."
>
>Why wouldn't the connection handle work for a particular form? I have checked to make sure that the variable does actually contain a valid handle, but for some reason, this one form won't use it. Can anyone explain this?
>
>Thanks!
The variable can have a valid handle but the connection could be closed for some reason. How did you get the handle? SQLConnect? Opening a view with a shared connection?
Mark McCasland
Midlothian, TX USA