This book covers what Access developers need to know about SQL Server. It includes detailed information on how to work with SQL Server outside of the Access environment and how to design efficient SQL Server databases. It outlines the planning that should go into a migration and the decisions that need to be made along the way.
Auflage
Sprache
Verlagsort
Zielgruppe
Professional/practitioner
Produkt-Hinweis
Broschur/Paperback
Klebebindung
Illustrationen
Maße
Höhe: 237 mm
Breite: 187 mm
Dicke: 37 mm
Gewicht
ISBN-13
978-1-893115-24-8 (9781893115248)
DOI
10.1007/978-1-4302-1131-0
Schweitzer Klassifikation
Russell Sinclair is an MSCD and the owner of Synthesystems, a technology consulting firm specializing in Visual Basic, SQL Server, and Microsoft Access development. Russell is the senior systems architect with Questica, Inc., a company specializing in software for custom-design manufacturers, and a contributing editor for Smart Access. In addition, he has extensive experience in Access and SQL Server development.
1 What Every Access Programmer Needs to Know about SQL Server.- 2 Why Migrate?.- 3 Planning the Upgrade.- 4 The Microsoft Wizard.- 5 Data Transformation Services.- 6 Using SQL Server 6.5.- 7 Using SQL Server 7.- 8 Enabling Data Access.- 9 Stored Procedures.- 10 Getting Connected.- 11 Coding with SQL Server Data.- 12 Optimizing Access for SQL Server.- Appendix A Selected Tables.- SQL Server Data Types.- Microsoft Access ODBC Registry Settings.
