Convert Access Database to Web Application

Migrate legacy Access systems to the cloud

migrate from MS Access to mobile-ready Web Application

Access vs Cloud

Do you have an MS Access Database and are exploring options to convert it to a web-based application?

Some general assumptions about MS Access:

We have huge experience in creating and maintaining Access-based applications and we understand that Access is a very convenient tool in particular cases.

However, there are strong trends towards web-based applications rather than platform-specific applications like MS Access.

What are the benefits of web based applications?

How to convert MS Access database to Web application?

So, what can we do with legacy MS Access databases?
Are there any ways to convert or migrate old desktop database to web-based application?

The answer is "possible, but not easy".

Generally, the steps to convert MS Access database to web-based are:

  1. import/migrate data from Access tables into MS SQL Server (alternatively MySQL or any other DBMS).
    No need to buy full SQL Server, usually free SQL Server Express edition is more than enough.
    There is a good tool for that - SQL Server Migration Assistant for Access.
    Watch out for Incompatible Access Features!

  2. recreate Queries as Views
    Queries in MS Access used quite widely, but Migration Assistant will help only convert SELECT queries and even not all of them.
    Just because Access queries could contain parameters from the linked forms or human entries. Such queries might need to be re-created from the scratch. Same about INSERT, UPDATE or DELETE queries.

  3. recreate Forms
    Once data is migrated to SQL Server, now you need to basically create a db-backed website using your favorite programming language - ASP.NET, PHP, Node.js, Java, Python, etc...
    While re-creating forms appearance could be relatively simple using modern UI prototyping tools, forms frequently has some business logic (VB code as well as SQL queries with parameters)

  4. recreate Reports
    Access reports need to be recreated in similar way as with Forms. Simple reports based on one query is easy to do with existing tools/libraries of the language you selected. However complex reports have to be created from scratch.
    Also, if you need to export your reports to Excel or PDF, you will need to use another library.

  5. rewrite custom VB code
    MS Access uses Visual Basic as a programming language. And you need to rewrite that in your programming language.
    Note, MS Access could contain code in macros and modules that not directly related to specific forms or reports. Don't forget that.

As you see each step might not be straight forward. Data might need to be restructured, Forms and Reports complicated, VB code - cumbersome.

Are there any services to automate migration?

Currently there are no automatic converters that can do that for you.

But we can do that and we know how to do that right. We can provide:

We can even merge several Access databases into one single Web Application.

Contact Us and we'll help you with your MS Access database.