Updating a table in VB 2008

I'm pretty sure that this should be simple enough to do but for some reason am struggling with it and trying to find out an answer too.

This is my first time at doing a project in VB where there's just a single table in access 07. Linking them up through the wizard, I've been fairly happy with that (nothing complex :D). However, now I've updated the table in Access and it hasn't changed in VB, I've then changed its local stored one but the dataset hasn't updated either, which I'd of thought it would of :S Is there a way to get it to update itself, or does it need to be re-linked?

Also, once the dataset starts to get dragged onto the form, with the default tool-bar that pops up, what needs to be edited to make the save, add & delete buttons work and write to the locally stored database?

I know that these both are probably dead simple to do, but I'm very new to doing programming with databases in VB, so would very much appreciate the help :)

This is my first time at doing a project in VB where there's just a single table in access 07. Linking them up through the wizard, I've been fairly happy with that (nothing complex ). However, now I've updated the table in Access and it hasn't changed in VB, I've then changed its local stored one but the dataset hasn't updated either, which I'd of thought it would of :S Is there a way to get it to update itself, or does it need to be re-linked?

Also, once the dataset starts to get dragged onto the form, with the default tool-bar that pops up, what needs to be edited to make the save, add & delete buttons work and write to the locally stored database?

I know that these both are probably dead simple to do, but I'm very new to doing programming with databases in VB, so would very much appreciate the help
Seer73 is offline Report Post Reply With Quote

In my signature there is a link "I swear I saved my data, where'd it run off to?" ... read it, check it out... see if it applies. Odds are, the database you're updating isn't the one you think it is...

-tg

No luck I'm afraid, I went for the copy with newer option and nothing happened :( thanks anyway :)