For the i Series ODBC driver verision 9. there are settings that can cause diffculty and seem to work for updating or selection, but not both.

In the Performance tab, under the Advanced button, these are the settings: Open All Cursors as updateable --Set ON for update, Off for select Retrieve extended column information --set ON for update, Off for select I've had to set up 2 different datasources, one for read, and another for write.

updating tables in sql server-12

Thanks, Basu Journaling is how the AS/400 tracks activity against a table.

The journal then can be used in recovering a table by either applying activities or removing them.

This can be due to several reasons: Assuming you can edit your table, your query may fail and display this error message when you run it: Operation Failed If so, check out our paper on Error 3073: Operation must use an updatable query: Dealing with Non-Updateable Queries and the Use of Temporary Tables in Microsoft Access which discusses some of the issues and workarounds.

Make sure you spend the time to understand how to create and use Update Queries in MS Access.

When confronted with the limitations of what you can do with SQL Syntax, you can supplement Access update queries with your own functions letting Access take care of updating the records, while you focus on the calculations.

I am using Linked Server to update AS/400 tables since a lot.

You can specify the records to modify by applying a filter (WHERE clause) and linking the table to other tables and queries.

The updated value can be: UPDATE is 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 US: In this example, the Contacted field is incremented by one if the record has Called = True.

Each contact may have a different value in its Contacted field depending on how many times it was contacted in the past.

In this example, the address records are updated with the City and State value from a zip code lookup table.

Any public function that you create in a standard module can be used in a query.