This article was previously published under Q301413
This article has been archived. It is offered "as is" and will no longer be updated.
Moderate: Requires basic macro, coding, and interoperability skills.
This article applies only to a Microsoft Access project (.adp).
The Configuring SQL Server 2000 Desktop Engine white paper (AccSQL02.doc) provides an overview of how to use Microsoft Access 2002 with Microsoft SQL Server 2000 Desktop Engine (SQL Server Desktop Engine). Topics that are covered in this white paper include SQL Server Desktop Engine installation options, resolving connectivity problems, and SQL Server security issues with Access 2002.
The following file is available for download from the Microsoft Download Center:
The AccSQL02.exe file contains the following file:
AccSQL02.doc A Microsoft Word document
For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base:
119591 How to Obtain Microsoft Support Files from Online Services
Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help to prevent any unauthorized changes to the file.
The Configuring SQL Server 2000 Desktop Engine white paper contains the following topics:
OVERVIEW OF SQL SERVER 2000 DESKTOP ENGINE
SQL SERVER DESKTOP ENGINE INSTALLATION
Upgrading from MSDE 1.0 or SQL Server 7.0
SQL Server Logon
Creating an Installation Log File
Reinstalling SQL Server Desktop Engine
RESOLVING CONNECTIVITY PROBLEMS
Connecting via TCP/IP to a SQL Server Named Instance
Server Configuration for TCP/IP
Modify Access ADP Connection Information for TCP/IP
Connecting via Named Pipes to a SQL Server Named Instance
Named Instance with Windows NT
Modify Access ADP Connection Information for Named Pipes Connection
Problems with MDAC 2.5 Users Connecting to SQL Server Desktop Engine
ACCESS 2002 AND SQL SERVER DESKTOP ENGINE SECURITY
Changes to Security Dialog Boxes
Granting Permissions to the Database
Enabling the System Administrator (sa) logon
Microsoft Office XP Developer
SQL Server Stored Procedures
Assigning permissions to a new user
Assigning permissions to multiple users
FOR MORE INFORMATION