Conversion white paper is available in the download center (319400)


The information in this article applies to:

  • Microsoft Access 2002
This article was previously published under Q319400
For a Microsoft Access 97 version of this article, see 151193.
For a Microsoft Access 2000 version of this article, see 237313.

Novice: Requires knowledge of the user interface on single-user computers.

This article applies only to a Microsoft Access database (.mdb).

SUMMARY

The "Microsoft Access 2002 Conversion" white paper has useful information about how to convert databases that were created in earlier versions of Access to the Access 2002 file format. This white paper also describes the issues that you may experience when you save a database to an earlier version. The ability to save a database to an earlier version is a new feature in Access 2002. This feature allows you to save your Access 2002 database to the Access 2000 and Access 97 file formats.

MORE INFORMATION

The following file is available for download from the Microsoft Download Center:

Conv2002.exe

The Conv2002.exe file contains one file:

File NameDescription
Conv2002.docAccess 2002 Conversion White Paper in Microsoft Word 97-2002 format

Release Date: Mar-5-2002

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.

Installation Instructions

Save Conv2002.exe to any folder on your hard disk. Then, double-click Conv2002.exe to expand the white paper. Open Conv2002.doc in Microsoft Word.

Topics

The Conversion white paper contains the following topics:
  • OVERVIEW
    • Supported Access File Formats
    • Enabling Earlier Versions of a Database
    • TIP: Use Front-End/Back-End Applications to Share with an Earlier Version
  • CONVERTING A DATABASE
    • Permissions Needed to Convert a Secured Database
    • MDB and ADP Files
  • BEFORE YOU CONVERT
    • Preventing loss of data
    • Naming Conventions
    • Converting Access Basic and VBA Code
    • DAO 2.5/3.5-Compatibility Library
    • DAO vs. ADO
  • CONVERTING MICROSOFT ACCESS 97 DATABASES
    • Converting Databases with Many Code or Class Modules (or Both)
    • Converting Databases from Previous Localized Versions of Access
    • Name AutoCorrect Does Not Work with Converted Databases
    • Converting Secured Databases
    • Converting Add-ins and Library Databases
    • Converting Replica Sets
    • "The Visual Basic for Applications project in the database is corrupt" Error Message
    • MDE Files
    • Intrinsic Constants
    • DAO vs. ADO
    • Converting Source Control Databases
    • SendKeys Statement and Macro Action
  • CONVERTING MICROSOFT ACCESS 95 DATABASES
    • DAO 2.5/3.0-Compatibility Library
    • DAO vs. ADO
    • Converting Databases with Many Code and/or Class Modules
    • Converting Databases from Previous Localized Versions of Access
    • Name AutoCorrect Doesn't Work with Converted Databases
    • Converting Forms and Reports with Many Controls
    • Converting Secured Databases
    • Converting Add-ins and Library Databases
    • Converting Replica Sets
    • DoCmd Statement
    • SendKeys Statement and Macro Action
    • Intrinsic Constants
    • Conflicts with Reserved Words
  • CONVERTING MICROSOFT ACCESS 2.0 DATABASES
    • DAO 2.x Library
    • DAO vs. ADO
    • Converting Databases with Many Code and/or Class Modules
    • Converting Databases from Previous Localized Versions of Access
    • Name AutoCorrect Doesn't Work with Converted Databases
    • Conversion of a 2.0 Database Adjusts Margins of Reports to Fit Default Unprintable Region
    • Converting Forms and Reports with Many of Controls
    • Converting Secured Databases
    • Converting Add-ins and Library Databases
    • 16- and 32-Bit ActiveX Controls (OLE Custom Controls)
    • 16- and 32-Bit API Calls
    • 16-Bit ODBC Data Sources
    • Tables with more than 32 Indexes
    • DoCmd Statement
    • SendKeys Statement and Macro Action
    • TransferSpreadsheet Action
    • The TransferText Actions
    • Comparisons Involving Null Values
    • Intrinsic Constants
    • Conflicts with Reserved Words
    • Standard Module/Class Module Name Conflicts
    • Module Name/Procedure Name Conflicts
  • ISSUES ENCOUNTERED WHEN YOU SAVE AS PREVIOUS VERSION
    • User Defined Properties Are Not Saved When Converted to Previous Version of Access
    • Import Specifications Not Saved When Converted Database Is Converted to Previous Version
    • Save as 97 Creates an Unsecured 97 Database
    • Missing References After You Convert an Access 2002 Database to Access 97
    • Memo Field Indexing
    • Replicated Databases
    • Access 2002 System.mdw Cannot Be Saved as a Previous Version of Microsoft Access
Modification Type:MinorLast Reviewed:8/25/2004
Keywords:kbdownload kbhowto KB319400
©2004 Microsoft Corporation. All rights reserved.