Migrating MS Access 2003 Database Applications to SQL Server 2005/VB RRS feed

  • General discussion

  • Hello all! First time post this one.

    My work requires me to look after 5 MS Access 2003 Database applications. These are now legacy applications and we are considering moving these to a SQL Server 2005 backend/VB .NET frontend combination.

    Some questions to start off:

    1. Apart from a download copy of SQL Server 2005 and a MS Visual Studio License, are there any other tools I might require to do this work?

    2. Considering that 80% of forms and reports from MS Access are to be recreated, am I able to go forth boldly with the assumption that all data in tables will successfully be converted to SQL Server 2005 tables using SSMA?

    3. Will the VBA coding in MS Access DB Applications need to be rewritten completely, or is there a way to deal with this such as embedding the code, etc?

    4. How easily can the SQL queries (union, join, crosstab) in the MS Access DB Applications be converted, or do these need to be recreated?

    All feedback on the above is welcome. Thank you.

    Tuesday, November 6, 2012 9:47 AM

All replies

  • Hello,

    Take a look at DBForms tool  

    2. It is able to convert MS Access forms to ASP.NET . Table structure and data will be transferred to SQL server.

    3. It doesn't support VBA code migration :(

    4.  SQL queries will be converted to MS SQL views.  

    • Edited by DMSoft Tuesday, November 6, 2012 8:31 PM
    Tuesday, November 6, 2012 8:31 PM