>I have a form where I'm adding a new record. The dataenvironment of the form is a multi-table view of some MS SQL Server tables.
>
>I am testing the form, and when I click on my Save command button, I get a "Connection ConnectName is Busy" error. If I then wait a few seconds and click on resume, everything works fine.
>
>This happens when I am the only one connected to the SQL server. None of my views have the option selected to share the connection. The error occurs when I try to INSERT INTO a view that is not in the data environment.
>
>Any ideas?
>
>Jeff

i dont recomment u that use createconnection() function or somethign else..... try using =SQLCONNECT and =SQLEXEC.....