A popular feature is the ability to change the PLC address information for multiple objects simultaneously. Let us assume that you have just replaced one of your PLCs to obtain more functionality. The old one is a Siemens serial 3964R/512K interface driver (ID no. 2) and the new one is a Siemens S7 protocol driver (ID no. 8). To change all the IDs from 2 to 8, you must first extract the relevant fields and then make an update query.
Extract the relevant fields from the STANDARD and ATOM tables.
In the query design mode, right-click in the upper pane of the window and select Query Type ® Update Query.
In the DRIVERID column, type 8 in the Update To field and 2 in the Criteria field.
Click the Run Query button, 
. A confirmation message appears informing you that this is an irreversible operation.
Click Yes. A second confirmation message appears telling you how many records you are about to update.
Click Yes.
Result: All driver IDs have now been changed from 2 to 8.
