O'Reilly logo

F. Scott Barker's Microsoft® Access 2000 Power Programming by F. Scott Barker

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CONVERTING EXISTING APPLICATIONS

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.

Starting with a Well-Designed Database

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?

Note

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required