Mar 28, 2008

Mobile web application for social services agency

This project involved bringing access to data, and the ability to create and update notes and records from mobile devices such as the BlackBerry and the HTC Windows smart phone. The application was written in classic ASP because the newer technology generated web pages that were too complex for the Blackberry to render. The back end runs on a Windows Internet Information Server (IIS) and a Microsoft SQL Server database. Parts of the application previously used Microsoft Access clients, which obviously would not translate to a mobile environment.

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.