>>I give my user's the ability to define a connection using:
>>
>>CREATE CONNECTION ?
>>
>>There doesn't seem to be any to wait for them to finish specifying connection criteria before the program continues. Any ideas?
>>
>>tia
>>
>>Lee
>
>CREATE CONNECTION (with no parameters) is not available in distributed executables. If you want the dialog box to appear, user needs to have a copy of VFP. You can create your own form that resembles the create connection dialog box and then issue Create Connection with the parameters in your form.


I didn't see that this command was not available. Thanks for pointing it out.

Kamal, I am writing a data conversion tool which will convert data from dissimiliar data structures. As long as my user's can create a DSN, I want to allow them to specify that DSN/connection so they can import table and fields names. This allows them to map those fields into the new structure. By using connections we can convert between any database where we can set up an ODBC connection.

Thanks again,

Lee