Article ID: 301413
Article Last Modified on 8/25/2004
APPLIES TO
- Microsoft Access 2002 Standard Edition
This article was previously published under Q301413
Moderate: Requires basic macro, coding, and interoperability skills.
This article applies only to a Microsoft Access project (.adp).
SUMMARY
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.
MORE INFORMATION
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
- Installation Options
- Installation Folders
- Instance Name
- 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 Integrated Security Enterprise Manager Microsoft Office XP Developer SQL Server Stored Procedures
- Assigning permissions to a new user
- Assigning permissions to multiple users
MONITORING CONNECTIONS
- Concurrency Violations
CONCLUSION FOR MORE INFORMATION
Additional query words: inf
Keywords: kbdownload kbgraphxlink kbfile kbsetup kbconfig KB301413