HELP!!! - Urgent assistance is needed



Hi

BDS 2006

MSSQL 2000

I have faced a very strange and unexplainable error.

I do have a MS SQL database, containing a number of interrelated tables.

A Mastertable, and > 15 detail tables.

In my datamodule, I have an ADODataset for each table, and arranged
MasterDetail relations in the datamodule (MasterSource-->MasterFields etc.).
All my keyfields are 'UniqueIdentifier' type

I have a DatasetProvider pointing on the mastertable, and by adding fields
in the field editor, I see all the fields from the database, and also the
datasetfields (Nested datasets).

Apparently, when I have more than 13 details tables (nested datasets), and I
click on the "add fields" on the editor, (or trying to open the CDS in
designtime, also when no persistant fields are added) I get following
errormessage:
"Operation not applicable"

Regardless which one I remove, I again can add the fields, so I presume it
has something to do with resources.

Of cource, same error comes in runtime by attempting to open the CDS

The ADODatasets can all be opened without problems


I have no idea where to search

Any help will be highly appreciated

Anders



.