Project description MICROSOFT PROJECTS

Microsoft development, database development and database administration, web portals and OO development...

DB Migration – Microsoft Access, VBA, SQL, VB 6.0

UBS

MS Access, VBA, SQL, VB 6.0

UBS AG, Zürich, Schweiz

PROJECT LINK: Not available
People in the PROJECT: Stefan Troehler
PROJECT Duration: Jan 1998 - Oct 1999
PROJECT Value: SFR. 220'000.00

MICROSOFT

Project portfolio
0
HOURS REQUIRED
0
CUP OF COFFEE
0
LINES IN THE CODE
0
EXPERTS IN THE PROJECT

The migration of 200 databases from Microsoft Access 2.0 to Microsoft Access 97. Frontend and backend were migrated. Logic that was implemented using VBA or macros was checked and adjusted if necessary. This applied to both the user interfaces and the reports.

  • Migration of approx. 200 Microsoft Access 2.0 applications to Microsoft Access 97.
  • No tools may be installed on the system for the migration of the 200 Microsoft Access applications.
  • Create inventory of all existing Microsoft Access
  • Applications.
  • Identify applications and backups.
  • For backup copies and old data applications, the migration had to be carried out exclusively on Microsoft Access level.
  • In the current applications, the entire logic also had to be migrated
  • OCX component (Microsoft Visual Basic 6.0) developed, which documents the entire application in a text file and searches the documentation for various keywords. Based on the search results, the migration could be carried out.
  • Test the migrated applications.