- Now, as in Figure 18.64, you can see the linked SQL Server tables in the Access database
window.
FIGURE 18.64
Linked SQL Server tables in an Access front-end database.With the tables linked, you can proceed to create the Access front end for working with the SQL
Server data.
The SQL Server Migration Assistant for Access ..................................................................
There is an alternative to using the Upsizing Wizard: the SQL Server Migration Assistant for Access
(SSMA), a free Microsoft download, at http://www.microsoft.com/sql/solutions/migration/
access/default.mspx.
Compared with the Upsizing Wizard, SSMA has a more modern look and includes a number of
extra features, but as far as the basics are concerned, it should accomplish the same task: convert-
ing Access tables to SQL Server tables. However, at this time the SSMA does not support the new
Access 2007 .accdb database format, so if you attempt to use this utility to upsize an Access data-
base to SQL Server, you will just get a message saying “Unrecognized database format.”
Working with SQL Server Data 18