DataAdapter number of columns limitation?

[Kamil]

Hi

I'm trying to write strongly typed dataset.
Ma DB has Tables with more then 100 columns each.
Creating DataAdapter, DataSet and DataAdapter Commands by
wizard fails. Doing it manually is not pleaserfull.
I've discovered that when number of columns in table
exceedes 100 Then DataAdapter fails on creating Insert,
Update, Delete, Commands.
Why is it happening? Can I avoid it somehow
I'll add that I'm using C# and Access 2002.

Thanks for help
Kamil

 

[Miha Markic]

Hi Kamil,

If I remember properly, this is known limitation of designer.
If you wait for a day or two, I'll have an automated solution for you.

 

[Kamil]

Thanks

I'll wait just let me know when it's done or where to
look for it.