I've done plenty of searching through as many threads related to this issue and tried just about everything I've found, but to no avail.
I am using the VB that is included with Visual Studio 2005 and I have a secured access database that I connected to using a Dataset object. The form has some text boxes and combo boxes and loads just fine. I have a button that should add the data entered in the boxes as a new record. I would like to avoid the whole confusing approach of declaring a new data connection in the code and I should be able to use the Dataset object. But no matter how I try to do it it doesn't add the record to the database.
Could someone please explain to me how to do this? Thanks.