<P> A variety of upgrading options are available . After migrating the data and queries to SQL Server, the Access database can be linked to the SQL database . However, certain data types are problematic, most notably "Yes / No". In Microsoft Access there are three states for the Yes / No (True / False) data type: empty, no / false (zero) and yes / true (- 1). The corresponding SQL Server data type is binary, with only two states, permissible values, zero and 1 . Regardless, SQL Server is still the easiest migration, and most appropriate especially if the user does not have rights to create objects such as stored procedures on SQL Server . Retrieving data from linked tables is optimized to just the records needed, but this scenario may operate less efficiently than what would otherwise be optimal for SQL Server . For example, in instances where multi-table joins still require copying the whole table across the network . </P> <P> In previous versions of Access, including Access 2010, databases can also be converted to Access Data Projects (ADP) which are tied directly to one SQL Server database . This feature was removed from Access 2013 . ADP's support the ability to directly create and modify SQL Server objects such as tables, views, stored procedures, and SQL Server constraints . The views and stored procedures can significantly reduce the network traffic for multi-table joins . Fortunately, SQL Server supports temporary tables and links to other data sources beyond the single SQL Server database . </P> <P> Finally, some Access databases are completely replaced by another technology such as ASP.NET or Java once the data is converted . However any migration may dictate major effort since the Access SQL language is a more powerful superset of standard SQL . Further, Access application procedures, whether VBA and macros, are written at a relatively higher level versus the currently available alternatives that are both robust and comprehensive . Note that the Access macro language, allowing an even higher level of abstraction than VBA, was significantly enhanced in Access 2010 and again in Access 2013 . </P> <P> In many cases, developers build direct web - to - data interfaces using ASP.NET, while keeping major business automation processes, administrative and reporting functions that don't need to be distributed to everyone in Access for information workers to maintain . </P>

What is the purpose of using microsoft access