>>>>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!
>>>
>>>Is the form using a private data session? Just a WAG that this might cause a problem.
>>
>>The form is using a private datasession, but so are all the other forms that actually work with the connection handle variable.
>
>If you make it use the default data session, will it work?
Nope. It returns the same "Invalid Connection Handle" error message.