Deutsch   |   English
Contact us!

Access Migration: Our Service for Modern Applications

Access, a member of the Microsoft Office suite of applications, provides a low-barrier entry to database-based application development complete with masks, reports and all application logic. In the 1990s, it was used quite often by individual developers working in specialist departments as well as professional developer teams working for software companies. Developer teams, in particular, no longer consider Access to be the best choice. Access applications are not in compliance with modern architecture paradigms, are not usable with web and browser technologies and are perceived as being somewhat unprofessional by both developers and potential clients.

Access migration by fecher solves all of these problems at once: Using a proven tool-based process, fecher creates a functionally identical application that is based on the future-proof .NET framework with C# application logic, and which is flexibly usable on all devices as it is a true browser-based app. In the course of the migration project, you can also have the user interface modernized with new navigation, a responsive design or even a fundamental redesign of the masks.

Access Migration: Key Benfits

  • Converts your Access applications to .NET (C#).
  • Older Access applications will be maintained, further developed and expanded using the current Visual Studio IDE.
  • Old code can be further developed and modernized (object-orientation, multi-layer architecture etc.)
  • Full retention of all functions plus an improved user interface and deployment options.
  • A true browser application that is usable on all desktops and mobile platforms with no limitation.

Access Migration by fecher at a glance

Access – much more than a database

Although Access is commonly referred to as a database, it is actually much more than that. It is primarily a tool and a run-time environment for the creation and the execution of database applications. In addition to the database itself, Access also includes forms and reports as well as application logic in the form of macros or VBA code (Visual Basic for Applications, a Microsoft BASIC dialect).

In fact, the database itself now plays such a minor role - and has such drastic size, user-count and failure safety limitations - that many Access applications no longer even use the actual Access database and use Microsoft’s SQL Server for data storage instead.

Otherwise, the conversion to SQL Server or a cloud-based Microsoft Azure SQL database will take place during the migration project. By using Microsoft's SQL Server Migration Assistant (SSMA), a Microsoft tool specifically designed for this purpose, the conversion becomes relatively unproblematic. The switch may however encounter snags as the SQL syntax for the two databases is not identical. fecher then inserts its proprietary sqlTRANSLATOR middleware in between to translate the SQL statements into the syntax of the new target database.

Converting the Access software environment elements, namely the forms, reports and associated application logic, is the significantly more complex portion of any Access migration project. Forms are converted to .NET forms based on the Wisej framework. Reports are converted using the proven .NET reporting tool DevExpress. A specialized tool, fecher’s accessPORTER, is then used for these conversions and to adapt the VBA code and the macros to C#.

Tool: accessPORTER

accessPORTER analyzes the Access application source code from which it develops the needed mapping for the transformation to a true .NET project with C# as well as the declared forms in Visual Studio. The tool enables project-specific declaration of the translation schema. The Access environment functions for which there typically is no direct .NET equivalent will be supplemented via a supplied class library, so that the migrated code remains easily readable and can be easily maintained with the .NET tools and further developed over time.

The accessPORTER replaces the Access application's presentation layer via the Wisej framework, thereby generating a true browser application.  During the migration, the tool handles all of the necessary declarations and architectural adaptations. A Session Manager is implemented, for example, to manage all web users’ static objects.

accessPORTER is always used within the course of an Access migration project. When necessary, our specialists will implement any needed extensions for Wisej, integrate them with the existing framework and, using a proven procedure model, deliver a turnkey solution to you for a fixed price. 

Additional features

  • Integrated assessment to determine complexity and various metrics
  • Maintain the mapping rules in a repository
  • Multi-stage transformation for optimal structuring and referencing of the base libraries
  • Automated code compiler to quickly verify interim results

Result

  • Web application as an HTML5-based Rich Internet Application
  • Equivalent design and functionality
  • High level of scalability and performance
  • Delivery is a complete (100%), modern readable source code in C#

Licence model

  • The cost depends on the number of lines of code and any utilized controls from third-party manufacturers.
  • fecher can provide you with training sessions, workshops and support.

Your fecher project: phases, steps, milestones

  • Free rough analysis that includes an extensive information phase
  • Detailed analysis including proof of concept to generate a binding calculation
  • Modular approach for large projects

As with all of our migration projects, Access migration projects are always conducted according to a proven procedure model. The procedure model consists of multiple phases: In the evaluation phase, together with potential clients, fecher develops a solid decision-making basis for migrating your application. Also included in this phase is a fixed-priced offer keyed to the quantity and complexity of the code. Thereafter, the actual project can start, beginning with the implementation phase. At the end of the test phase, the turn-key deliverable to you is a completely migrated application that will run without restrictions in the agreed upon web and/or mobile environments.

The Framework: Wisej

Wisej is an open Web Integrated Server Environment to design, build, debug, and manage powerful Web Applications using C# or VB.NET in Visual Studio. With Wisej, you can develop applications which can be operated like desktop software. The necessary technical requirements are fully contained in the Wisej framework and handled by it independently. This allows developers to focus entirely on their projects without worrying about HTML, state management, Ajax callbacks or concurrency.  For more information on Wisej, including support and pricing, visit the Wisej website of our partner Ice Tea Group: www.wisej.com

We look forward to your challenge and working with you to move your company forward. Choose fecher now as your partner for Access Migration and future-proof your IT infrastructure!

Contact us now for a free analysis