![]() Reality sets in and the business owner seeks professional help. ![]() All of a sudden, the Access application is mission critical to the business, but it performs poorly and will not scale with the business. Over time the database becomes a Frankenstein with tables old and new bolted on to the application, large blocks of code that are not used or worse are not commented. Usually the person will not use relationships to maintain referential integrity, they use the database to maintain state by making copies of tables, and VBA or Macros are constructed without understanding encapsulation of functions or proper error handling. Initially the application is created with no real design. ![]() Unfortunately, this often means that a secretary or some non-professional programmer will create the LOB system using Access. It was also not intended for creating line of business (LOB) applications with complex logic and business critical data storage.īecause Access is easy to use, and because it comes bundled with Office, well-meaning business owners will often create LOB Applications using Access, thinking they are saving money and doing right by their business. Access is not meant to be used with high-stress, high-concurrency, 24x7 server applications, such as Web, commerce, transactional, and messaging servers. The sole purpose of Access was to create small office databases and to manage lists. To use the GEICO Insurance analogy, "It's so easy even a caveman can use it." Access is a very powerful desktop database that combines a database, user interface, programming language, and querying & reporting tools into an easy to use productivity tool. ![]() It comes bundled as part of the Microsoft Office Suite. There is no doubt about it Microsoft Access is a powerful tool. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |