Update an Access application

Asked

Viewed 93 times

1

What is the easiest way to upgrade an Access desktop application with VBA to a web application with sql server?

sql-server web-application vba ms-access office

  • What is the Access version? // Know SQL Server?

  • Access 2016. I know SQL but I am not administrator of the machines, that is, I have access restrictions.

  • I hope that the SSMA for Access works with the 2016 version of Access. The documentation contains only until Access 2010.

1 answer

1


Miguel, there are two update lines, which seem to me partially parallel: the migration of sgbd (Access to SQL Server) and the replacement of language/environment.

DATABASE

To migrate the Access database to SQL Server you can use the "Microsoft SQL Server Migration Assistant" (SSMA). Details in SQL Server Migration Assistant. There is extensive documentation on the specific variation for Access and I recommend attention in reading it, especially in the compatibility part.

Another alternative is to perform access upsizing, which is the process of migrating some or all database objects from an Access database to a new or existing SQL Server database. Is available in the guide Ferramentas de banco de dados, in the group Mover dados, item SQL Server. Note that the location may vary according to the Access version. Full instructions on Move Access data to an SQL Server database using the Upsizing Wizard.

APPLYING

On the web there are several articles about migrate access to web application. Have you had the opportunity to study any of them?

Browser other questions tagged sql-server web-application vba ms-access office

You are not signed in. Login or sign up in order to post.