InvalidOperationException on OleDb.OleDbDataAdapter.Update(Table)

Hey, I am getting the followng exception when I perform the subejct operation on a DataTable that represents a valid table in an access database.

"Missing the DataColumn 'Name' for the SourceColumn 'Name'."

I jumped through all sorts of hoops and had this working perfectly, but I run things in a certain combination and I get this error.  It has something to do with the combination of ways I am accessing the table -- when I take out a few previous reads and/or writes to the table, I don't get this error.  

But I'm sort of stabbing inthe dark, I don't know the meaning of or how to troubleshoot the error.  Any ideas out there?

thanks in advance!
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Does this sound familiar?

Without knowing more about what is involved when you "run things in a certain combination" I can't offer specific suggestions.  But that link considers the issue and, if it's not enough for you to debug it yourself, come back with a few more details.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
riceman0Author Commented:

You rock.  I scored that so high because it was absolutely killing me.  It was the exact same problem, I was using the same adapter for all tables, when I broked it up into a dedicated adapter for each table, it worked.  Thanks!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic.NET

From novice to tech pro — start learning today.