Results 1 to 4 of 4

Thread: Updating a table in VB 2008

  1. #1

    Thread Starter
    New Member
    Join Date
    May 2011
    Posts
    8

    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 ). 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

  2. #2
    New Member
    Join Date
    May 2011
    Posts
    1

    Re: Updating a table in VB 2008

    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

  3. #3
    PowerPoster techgnome's Avatar
    Join Date
    May 2002
    Posts
    34,687

    Re: Updating a table in VB 2008

    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
    * I don't respond to private (PM) requests for help. It's not conducive to the general learning of others.*
    * I also don't respond to friend requests. Save a few bits and don't bother. I'll just end up rejecting anyways.*
    * How to get EFFECTIVE help: The Hitchhiker's Guide to Getting Help at VBF - Removing eels from your hovercraft *
    * How to Use Parameters * Create Disconnected ADO Recordset Clones * Set your VB6 ActiveX Compatibility * Get rid of those pesky VB Line Numbers * I swear I saved my data, where'd it run off to??? *

  4. #4

    Thread Starter
    New Member
    Join Date
    May 2011
    Posts
    8

    Re: Updating a table in VB 2008

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

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width