DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 301413 - Last Review: October 24, 2013 - Revision: 1.0

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).

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:
AccSQL02.exe (http://download.microsoft.com/download/Access2002/whitepap/2002/WIN98Me/EN-US/AccSQL02.exe)
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  (http://support.microsoft.com/kb/119591/EN-US/ ) 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
Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use (http://go.microsoft.com/fwlink/?LinkId=151500) for other considerations.

Applies to
  • Microsoft Access 2002 Standard Edition
Keywords: 
kbnosurvey kbarchive kbconfig kbsetup kbdownload kbfile kbgraphxlink KB301413
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support