Microsoft Office Access 2007 provides a number of tools for updating existing records, including datasheets, forms, queries, find-and-replace, and the new Data Collection feature.
As you proceed, remember that updating data is not the same process as entering new data.
I think we here should give most generic and trouble-free answers.
UPDATE is especially useful when you want to change many records or when the records that you want to change are in multiple tables. The following example increases the Order Amount values by 10 percent and the Freight values by 3 percent for shippers in the United Kingdom: Sub Update X() Dim dbs As Database Dim qdf As Query Def ' Modify this line to include the path to Northwind ' on your computer.
Instead, a typical Access database is a a collection of tables, plus a set of objects built around those tables — forms, reports, queries, and so on.
In addition, those objects must adhere to a set of design principles or the database will either work poorly or fail altogether.
In Scope = SWITCH (Analysis.[Test Area] = "NA", False, True, True), Components.However when I make a selection query (same way as above without the update option) it neatly displays the connected ID (primary key) and the two fields I like to manipulate.I tried both the "linked" and "copy into new table" options. I spent a few hours delving in this issue this morning.Large updates become much easier to perform when you understand some of the basic principles of database design.An Access database is not a file in the same sense as a Microsoft Office Word 2007 document or a Microsoft Office Power Point 2007 slide deck.