TG,
All of those columns exist in the Vendor table. When just those two columns are in the select command it will let the fill() happen; but the insert fails with "Field not member of adapter.insert()". I am wondering if somehow the adapter got screwed up and only put those in the class. I...
TG, I can only get the fill method to work with two columns in it; VendorNumber and VendorName. If there are any other columns in the fill.command.text it fails.
best regards,
TejasT
TG I did try the snippet you gave me; it did produce the error dialog as you stated.
My question is though; The only required field is the VendorID field which is a autoincrement field and is filled in the addnew(); So is it that field?
TejasT
I am fairly new to vb.net 2005. I am not sure why I am getting an OleDB Unhandled exception error # -2147217904 on a Adapter.fill(). It was working with only two parameters then when I added the rest of the needed parameters I started getting this error. This is updating a Access 03 database...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.