Once you have transferred objects from Microsoft Access to SQL Server, you will probably need to modify code in the original Microsoft Access database so that it functions properly with the new SQL Server database.