[RESOLVED] Query to complex- How to use multiple table adaptors with a single binding navigator

[MechEng]

I am using VB2005 with ACCESS2003 Database and run into the problem of too many fields in a database table. I can bind to the database and fill my datatable, but I can not update the database without getting the “Query too Complex” error. I currently have ~115 fields in a single table and all of these fields are unique and associated with each record.

I can break the data into two tables, but I have run into the problem of having two table adaptors, two binding sources, etc. That is fine, but how can I navigate through the datatables with a single binding source navigator? The two datatables need to be in sync because combined they complete a record dataset.

I believe I have read all the relevant posts, but I have not yet found a solution. I have loaded the SQL server on my PC, but this is really foriegn to me and I prefer to stick with ACCESS DB if possible.

Any guidance is really appreciated in advance.

[stanav]

Write your own insert, update and delete queries and assign them to the dataadapter. I once worked with an Access DB wich had a table with about 240 columns and that was what I had to do.

[MechEng]

That sounds like good advice... more work, but good advice. Thanks.