>I build a DE class with several CA in it. The DE is based on ADO DataSourceType. All ca is based on DE DataSource. But when I create form and put that DE class in it after I run it, Only the first (by creation) CA is open, all others are closed. Why?
>
>P.S. DE AutoOpenTables = .t.
>
>I run a test & when the form loads CursorFill Method of every CA is invoked.

In addition to what Doug replied, you can use my free CA VCX Builder to create a VCX with sub-classed CAs for all your tables. These can use ADO where you do not have to deal with the ADO connection objects for every instance. The source code is provided and extensive comments are near the beginning of the CABuilder PRG file. Just click the FoxPro Tools link at http://www.mctweedle.com