Update an Access application

Question

Update an Access application

Navigation

#1 by (1 votes)

1

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

sql-server vba ms-access office

asked by anonymous 22.04.2017 / 00:58

1 answer

Is it possible to return 2 values in an Ajax? How to execute a .bat file from an algorithm in C?

score 1 · Accepted Answer

Michael, 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 Wizard" (SSMA). Details on SQL Server Migration Assistant . There is a lot of documentation on the specific variation for Access and I recommend reading it, especially in the compatibility part.

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

APPLICATION

On the web there are several articles on migrate application access to web . Did you have the opportunity to study any of them?