ERPlite Design Summary

• Thank you for using ERPlite, the Microsoft Access based MRP software designed for small companies.
• This release includes an mdb FrontEnd(ie source code or open source). Forms, Reports, Macros, Queries and Modules are customizable.
• The regular 30 day ERPLite evaluaton copy that is downloadable from our website  is split into a backend (DbM_be.mdb) and FrontEnd (DbM_fe.mde). The backend contains the data and resides on the server PC. The FrontEnd is stored on every Client PC and connects to the BackEnd via the LAN in order to share data with all users.
• The mde version makes the Forms ,Reports, Macros and Modules read-only (Tables and Queries are read/write). Any VBA code is not visible, nor is it changeable.
• Since ERPlite is designed as a complete solution, the mde frontend is all that many companies need. In fact, it reduces support needs because users cannot change it.
• However, some companies need to customize ERPlite to better exploit the database in making their company more efficient and competitive. The source code version of ERPlite allows creation of custom queries, forms, reports, macros, and modules using standard Microsoft Access wizards and/or programming.
• ERPlite also contains many ActiveX components that you can use to create new functionality. These components include methods and properties to: update the dynamic count, exploded BOM's, manage the site license etc. Use of these components is very simple VBA programming. Thus, your staff can customize ERPlite without having to learn or do complex Visual Basic programming. Perusal of the visible VBA code in ERPlite will give most programmers all the information they need to use these reusable components to add functionality to ERPlite.   Live Long and Prosper!!!