31 May 2006

Real World Access (13)

One of a series of articles about where Microsoft Office Access applications have found a real-world niche.

Pat Hartman's hair care

Clairol, manufacturers of hair care products, converted their existing applications to SAP but SAP didn't provide all the functionality they needed so I developed an Access application that worked with SAP to produce workorders for the shop.  The application managed tables that stored the formulation instructions for each product.  SAP held the Bill of Materials and calculated demand.  A nightly batch job imported the SAP production orders and my application used them to calculate the quantities of each material required to produce the requested batch size and printed the shop floor paper at the appropriate work stations before start of shift each day.  The application was two Access databases, one for user interaction and the second to do the nightly processing and they both linked to an Oracle back end.


Powered by Qumana


Post a Comment

Links to this post:

Create a Link

<< Home