>I've got a VFP program which is installed at 2 separate community Mental Health Facilities. Recently, I added some ODBC connections to a special DBC set up to just handle the remote views to the SQL Anywhere files. I am getting lockups at 3 of the 5 workstations at one site, and no lockups (out of about 10 workstations that run it) at the other site.
>
>The facts:
>1. Sybase SQL Anywhere Database Engine Version 5.5.04 Build #1980
>2. The DBC was used prior to this last revision (of the VFP program) that I sent them. There were no problems prior to the latest revision.
>3. It appears to lock up every time it closes the connection (SELECT PATIENTS/USE) on any of the screens which use the DBC. I don't have the tables in the data environment because they might not use those tables (if they don't have the SQL Anywhere program, it doesn't attempt to use the files). So, in the Destroy method of the form, I have a
>IF USED('Patients')
> SELECT Patients
> USE
>ENDIF
>
>Any help would be appreciated.
>Joy Ruhe

Try moving the code to the form's Unload method. The Destroy method fires before the Destroy of controls on the form, so you might be trying to close the table while a data-bound control on the form still exists.

The Unload method is the last one to fire before the form or formset is released.