thanks Tim, this gives confidence in MM and it's community (=Mr Tim B.). I was away for 3 months earning a buck. I am catching up again..

see you, leon

>>Thank-you sir!
>
>Alan, Leon, and Guy
>
>I have tracked down what is causing the problem but not why. I notified Kevin so he can look at it, but for now if you want to run the Customer Orders form with SQL you can just add this: In the business object project there is a OrderDataAccess class under the Order folder. In this class there is an override for CreateDataAdapter. Before returning the DataAdapter just add a check for null and create a SqlDataAdapter like this.
>
>

>/// <summary>
>/// Factory method that instantiates the data adapter
>/// </summary>
>/// <returns>Data Adapter</returns>
>public override System.Data.IDataAdapter CreateDataAdapter()
>{
>     if (this.DataAdapter == null)
>          this.DataAdapter = new SqlDataAdapter();
>
>     return this.DataAdapter; ;
>}
>

>
>This isn't the fix for this permanently and would cause a problem trying to run with Fox data but will get the form running with SQL data for now.
>Tim