After you decide to migrate an existing file-server application to client/server, you should review your data structure to ensure that you have a well-designed, properly normalized database design. Then you'll need to prepare any existing queries, forms, and reports for the migration.
When you're ready to convert your application to SQL Server, you should first step back and analyze your data model. Is it properly normalized? Do any changes need to be made before the migration?
You should make changes to the Access database rather than assume that it's easy to make changes when the data structure exists in SQL Server. Changing SQL Server database structures can be very ...