In Microsoft® Access, most database objects are created interactively using a design wizard. When migrating to Microsoft SQL Server™, these objects must be re-created in SQL Server by writing an object creation script or working interactively with SQL Server Enterprise Manager.
If you created any Access database objects using a data definition query, the query can be modified to meet SQL Server specifications. Run the modified script through SQL Server Query Analyzer to create the new database objects.