Top Knowledge Base Articles for Access 2000 Developers

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

Microsoft Corporation

January 2000

Applies To: Microsoft® Access 2000

Summary: We dove deep into Microsoft Product Support's treasure chest of product knowledge, tips, tricks, and workarounds, and surfaced with this list of the ten most valuable topics for Access 2000 developers. (3 printed pages)

Access 2000 Frequently Asked Questions

http://support.microsoft.com/support/access/content/faq/faq2000.asp

This Knowledge Base article provides answers to popular questions about Access 2000.

Access 2000 Support Downloads

http://support.microsoft.com/support/downloads/lnp579.asp?fr=1&pa=1

This page provides links to service packs, add-ins, and white papers available for download.

Database Normalization Basics

http://support.microsoft.com/support/kb/articles/Q209/5/34.ASP

"Normalization" is the process of organizing data in a database, which includes creating tables and establishing relationships between those tables according to certain rules. This article explains database normalization terminology for beginners. A basic understanding of this terminology is helpful when discussing the design of a relational database.

Determining If You Are Running MSDE or SQL Server 7.0

http://support.microsoft.com/support/kb/articles/Q199/3/95.ASP

To see whether you are running Microsoft Data Engine (MSDE) or Microsoft SQL Server 7.0, you can check the Sqlstp.log file located in your \Windows or \Winnt folder.

How to Install Access 97 and Access 2000 on the Same Computer

http://support.microsoft.com/support/kb/articles/Q241/1/41.asp

How you install Access 97 and Access 2000 on the same computer depends on whether one of the versions is already installed or whether neither is installed. The installation instructions in this article cover all scenarios.

Information About Data Access Pages

http://support.microsoft.com/support/access/content/acc2000dap.asp

This Knowledge Base article includes links to the most current white papers about data access pages.

Differences Between Retail and Run-Time Microsoft Access

http://support.microsoft.com/support/kb/articles/Q208/7/30.ASP

This Knowledge Base article summarizes the differences in the user interface between the run-time version of Microsoft Access and the full, retail version.

Understanding Relational Database Design

http://support.microsoft.com/support/kb/articles/q234/2/08.asp

The Reldes00.doc Word document (downloadable from this page) shows you how to plan and design an Access database from the ground up. For practical examples, it uses the database design of the Northwind Traders sample database included in the Microsoft Access package.

Updated Version of Microsoft Jet 4.0 Available in Download Center

http://support.microsoft.com/support/kb/articles/q239/1/14.asp

The Jet40SP3.exe file contains an update of several .dll files that are included with products that incorporate Microsoft Jet database engine 4.x. Version 4.0 SP3 provides an improved Compact utility that combines Compact and Repair into a single process.