How would I update a whole ACCESS database???

• Art102

  I get that quite a bit: I use VB2005Express - it does have a cut down version of the MDSN library/help, as stated in the descriptive comparison of the Visual Studio versions.

  In that case, you will have to go to the MSDN (MSDN2) online library.

  (hmmm, another reason to upgrade, perhaps )

  
  
  

• TMacPhail

  You might try using a "UNION" statement. This would allow you to join together multiple tables at the same time. Granted, you might have to create the SQL statement yourself during run-time, but it should allow you to get data from multiple tables at the same time.
  

• mesh

  Thanks for the ideas and replies but I was hoping for either a tutorial or an example of how someone else has done it with a little nudge of code....

  Is it just me or is the documentation for VS2005 REALLY BAD It seems like no matter what I search for I get something like this:

  The index entry you selected has no target topics associated with it.

  To view topics related to the index entry

  • Click one of the child items listed below the index entry.

  See Also

  Then you click a subitem and get even less!!!!!

  The documentation needs some work......

  
  
  

• Assimalyst

  If you have the 2006 data open in a datagridview, and you open the 2007 data in a second datagridview you can use a 'for each row in' to traverse the 2007 grid and 'insert into' the other grid then save the now composite detail.
  
  

• mangelp

  What version of VB do you have

  
  
  

• Thomas Lee

  I have VS2005 PRO.....
  
  

• CamCC

  
  You can probably do this through SQL commands, provided that you know all the tables that need to be updated. Is there anything other than data that needs to be updated Table structures QueryDefs Reports

  
  
  

• RFewing

   

  There an alternative architecture that could be adopted that will take care of your sychronization problems.

  You can always write a server that handles the I/O. When it does all the I/O itself, the server can queue the I/O requests and there woun't be any synching problems.

  
  
  

• patel_mitesh

  Assuming I'm understanding you're question. Here's what I would do:

  In your application include an update function and a way for the appropriate user to start it. The function would open a recordset to the new data and process each row.

  For each row it would check the old database and if it finds a matching row update the appropriate fields. If it does not find a matching row add a new row to the existing DB.

  If your application is in Access I would do it the same way by creating a subroutine in a module and creating a form to call the subroutine with the appropriate data.

  
  

• Grasssu

  Here's the structure.....

  One table in the 2006 Database that has 1200 records with 8 columns of specs....
  One Query that simply creates a single record for each MFG.....that is driven by the table and I have verified adding records to the table automatically updates the query....

  When the 2007 MFG specs come out I dont want to make a whole new database to dispurse....I would like to be able to keep a master DB on the web with ALL specs and when they connect it will ask them if they want to synchronize the local data with the online data and have a local up to date database......

  I have searched a bit for synchronization......merge and DB updates and I really cant find much that pettains to this. I KNOW it must be possible because there are a bazillion softwares that sync local to web data and visa versa....

  Thanks in advance for the solution......

  
  
  
• How would I update a whole ACCESS database???