That's great news.Thanks a heap.

>I use SQLSTRINGCONNECT() to crate a shared connection that all my CAs will use. I store this connection handle to my goApp.nConnectHandle property. In my CA base class, I set the DataSource to =goApp.nConnectHandle and DataSourceType to ODBC. No all "15" CA Subclasses inherit these settings and all use the same shared connection. In the property sheet when editing the CA base class, you must precede the goApp.nConnectHandle value for the DataSource property with an equal sign so it is evaluated at runtime instead of treated as a string.
>
>>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