Lakeshore Technologies’ database now accurately, and automatically, tracks revisions made to a material, all of the products the material is used in, and any other products the first set of products may be used in until all affected items have been updated. None of these updates affect previous records of incoming materials, or previously produced Lots. All of this creates an accurate history of exactly what a product consisted of at any given point at which it was produced.
With the data tables moved to a backend server, and the Access front end, multi-user accommodation is substantially increased. Much of the automatic updating, and many other resource-heavy queries were able to be moved to the server. This has improved performance overall.