Access Program Update Mechanics

When you introduce the stored procedure, you need to identify all the places in external applications where the data is read and then refactor that code to invoke the new stored procedure appropriately. You may discover that the individual programs require different subsets of the data, and therefore you may need to apply Add Read Method several times, one for each major collection of data elements.

In the following code, applications would submit SELECT statements to the database to retrieve customer information; but after the refactoring, they just invoke the stored procedure: