From Access to SQL Server

Although Microsoft's Access Database is extremely popular and adequate for smaller scale applications, many Access developers are discovering that their applications need a more robust, enterprise-ready database system like SQL Server. This book is designed as a guide for Access programmers loo...

Full description

Bibliographic Details
Main Author: Sinclair, Russell
Format: eBook
Language:English
Published: Berkeley, CA Apress 2000, 2000
Edition:1st ed. 2000
Subjects:
Online Access:
Collection: Springer Book Archives -2004 - Collection details see MPG.ReNa
Table of Contents:
  • 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