Microsoft Access documents in its Help and in The Microsoft Office 2000/Visual Basic Programmer's Guide how to use and program a Microsoft Access project that is connected to a Microsoft SQL Server database. You may need information about SQL Server to answer specific product questions you might have. The SQL Server documentation contains the following:
| Item | Description |
|---|---|
| Books Online | Comprehensive documentation for SQL Server 7.0, including programming reference and Transact-SQL reference documentation, conceptual information about SQL Server, and general instructions for using SQL Server. |
| Transact-SQL Reference Help | Reference information about Transact-SQL syntax.
Note This help information is available from the Access Help Contents window. |
| SQL Server Error messages | Reference information about SQL Server error messages, numbers, and recovery actions.
Note This help information is available from the Access Help Contents window. |
| Enterprise Manager Help | Help information about administering an SQL Server database. |
| Replication wizard | Help information about configuring and managing replication. |
| Client Configuration Utility Help | Help information about managing SQL Server network connectivity options. |
| ODBC Driver Help | Help information about creating SQL Server ODBC data source definitions. |
| Profiler Help | Help information about capturing SQL Server events in a trace file for analysis and replay. |
| Query Analyzer Help | Help information about a graphical user interface that is used to interactively design and test Transact-SQL statements, batches, and scripts. |
| Data Transformation Services (DTS) Designer Help | Help information about importing, exporting, and transforming a variety of data sources. |
| SQL-DMO | Context-sensitive help information that is available from the development environment for SQL-DMO objects, properties and methods. |
| The Pubs Sample Database | The traditional SQL Server sample database. |
| The Northwind SQL Sample Database | A new sample database that contains the same Access Northwind sample database tables with specific SQL Server examples. |