Hi Mark

Another CA related question. Your class creates a base class and subclasses of this for each table. So with a SQLServer Database with say 15 tables we get a class with 1 base class and 15 sub classes.

The question is :

Say I have a form which will need 5 of these sub classed CA's added to the DE. 1 - Parent 2 - Child and 3,4 5 as lookups on the form.

That is 5 tables, 5 CA's. Does that also mean 5 Connections?

IF so how then do I manage it so that only 1 connection is used for the form irrespective of the number of CA's added to the DE?

I believe that SQLServer works on a connection basis and that MSDE will slow down after > 5 connections.

Help please. I cannot afford to feed MS with so many licenses. Or am I totally wrong in my premise about connections?

Bernard