MS Access Migration to a Modern Web Application: Our Service
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.
Migrating MS Access to a web application with 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, ensuring high scalability, improved security, optimized data handling and file import capabilities. The new application is fully flexible and accessible 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. This approach for the modernization of legacy software is often more worthwhile for you than creating a completely new system.
Migrating and Improving: The Key Benefits
- Converts your Access applications to .NET (C#).
- Older Access applications will be maintained, further developed and expanded using the current Visual Studio IDE.
- Legacy code is transformed and optimized to enable further development with modern practices, including object-orientation and multi-layer architecture.
- 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.
- Recreates the original Access queries, reports, and forms as part of the migration process.
We found fecher’s fixed-price approach to migration and UI redesign to be very convincing.
Microsoft Access – Much More Than a Database
While Access is often seen as a database, it is fundamentally a versatile tool for creating database applications.This includes not only the storage of data but also the creation of interactive forms, dynamic queries, and detailed reports. Access also includes forms, tables, and reports as well as application logic in the form of macros or VBA code (Visual Basic for Applications, a Microsoft BASIC dialect). With its limitations in scalability and performance, migrating your Access application ensures future-proof capabilities while maintaining seamless access to your data and workflows.
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.
Smooth Migration to SQL Server or Azure with fecher's Expertise
When a migration to SQL Server or a cloud-based Microsoft Azure SQL database is required, this process becomes an integral part of 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.
Convert Microsoft Access Forms to Web Applications: Safe and Complete
Converting the MS Access software environment elements, namely the forms, reports, tables 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.NET 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 Microsoft 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.NET 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 MS Access migration project. When necessary, our specialists will implement any needed extensions for Wisej.NET, integrate them with the existing framework and, using a proven procedure model, deliver a turnkey solution to you for a fixed price.
The Full Value of Converting Your MS Access Database to a Web Application
Extra Options
- 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
- Option to include custom features for enhanced functionality
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#
- Improved data security and remote access support
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, Microsoft 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.
Information
An information package with reference examples illustrates the migration project process. We’ll answer any questions you may have in a face-to-face meeting or through an online demonstration. We’ll also advise you with regard to technology selection, various migration approaches as well as server and client platforms.
Rough Analysis
The assessment tool categorizes the source code into easy, moderately difficult and difficult tasks. The tool lets us estimate the time and effort required, the time frame and the cost of the migration project within a fluctuation margin between 10 and 15 per cent. There is no charge for the rough analysis.
Detailed Analysis
We examine all application modules for problem areas and dependencies. The potential client is given a results report, a fixed-price offer and a project-specific timetable for the transformation. We charge a flat fee for the detailed analysis; the amount depends on the size of your project and the target platform. Depending on the complexity of the application, this only takes a few days.
Project Setup
The migration project is set up based on the analysis results. Together with the client, we coordinate the precise timetable and the course of action to be taken. We define the target structure of the individual application modules and components together with the client, thus covering the entire application. At this point, we create a solid foundation for the migration workflow.
Code Transformation
One by one, we migrate all of the modules using our automated migration tools. We also adapt the source code, our tools and the transformation rules, if necessary. The end result can therefore be greatly individualized.
Code Finalization
Every migration project involves changes to the software architecture. In the finalization phase, the code is always systematically checked and revised to meet the new conditions. All of the remaining errors are found through exploratory testing and an extensive screen-video based test portfolio. Individual problems are solved using traditional debugging methods and the solution is applied to all comparable source code areas. More extensive problems are solved by adapting the transformation rules and recompiling, either partially or fully. Additionally, our specialists verify all masks, dialogs and reports as well as conduct basic tests.
Test Phase
When conducting acceptance testing, an understanding of the business logic is crucial. For this reason, such tests are conducted by the client as a matter of principle. Errors uncovered during this testing process will be remedied by our migration specialists and have full warranty coverage. This ensures that all aspects of the migrated solution work as expected, providing an optimal user experience.
Training/Coaching
We hold workshops and training sessions to introduce the developers to the migrated application and the Wisej.NET framework. This provides a solid foundation for successful further development. We can also offer seminars that provide more advanced knowledge, if desired. A worthwhile addition: To secure our ongoing support, even long term, consider a support agreement.
Further Development
The migration project leads to a long-term development process. Your developers can immediately make use of the new possibilities opened up by .NET and the Wisej.NET framework. When you are ready, for example, you can develop new front-end modules for mobile devices, recreate existing data queries or make cloud-conforming functional improvements that increase productivity. We’ll gladly assist you with these tasks, as well.
The Framework: Wisej.NET
Wisej.NET 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.NET, you can develop applications which can be operated like desktop software. The necessary technical requirements are fully contained in the Wisej.NET 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.NET, including support and pricing, visit the Wisej.NET website of our partner Ice Tea Group: www.wisej.com
fecher is also specialized in:
Learn more about how we transform WPF applications into browser-based apps.
Find out more about web enabling via migrating WinForms applications to web applications.