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