Mar 28, 2008

Business Basic accounting system converted to Access

This project saw the conversion of an extensive accounting system written in 1970's era Business Basic to Microsoft Access for a major accounting firm. Data from the Business Basic files was extracted and imported into Access tables. Interesting issues included data concurrency when moved from a single central file system and Basic execution environment to a system distributed to many user workstations. The resulting system is comprised of about 100 forms and 50 tables running on 20 workstations.

In addition to bringing the system into 21st century technology, it has made it easy to create satellite versions that can be downloaded to run on a notebook computer, taken to a client, and then have the related data returned to the server afterwards. Biggest challenge? Adapting Access forms to work in the same manner as the previous character mode user interface.