About getting help on SQL Server (ADP) - Access

Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Email this link

Printer-Friendly Version Bookmark and Share

About getting help on SQL Server (ADP)

Applies to: Microsoft Office Access 2003

Note The information in this topic applies only to a Microsoft Access project (.adp).

Microsoft Access documents in its Help system how to use and program a Microsoft Access project (Microsoft Access project: An Access file that connects to a Microsoft SQL Server database and is used to create client/server applications. A project file doesn't contain any data or data-definition-based objects such as tables and views.) that is connected to a Microsoft SQL Server database. However, you may also need additional information about SQL Server to answer specific product questions you might have, such as reference information on Transact-SQL or the SQL Server Enterprise Manager.

Show Access to SQL Server Books Online and Transact SQL Reference information

The primary source of information about Microsoft SQL Server is SQL Server Books Online. If you have access to SQL Server 2000 on either a local or remote computer, then you have access to SQL Server Books Online through the Start menu. However, if you don't have access to SQL Server Books Online, you can download it from the SQL Server Books Online download Web page.

Show An overview of the SQL Server documentation

SQL Server documentation contains the following information.

Item	Description
SQL Server Books Online	Contains comprehensive documentation about SQL Server 2000 including: Conceptual information. General instructions. Reference information about Transact-SQL syntax. Reference information about SQL Server error messages, numbers, and recovery actions. General programming references.
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 Distributed Management Objects (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 sample database similar to the Access Northwind sample database with specific SQL Server examples.