Microsoft KB Archive/208769

= List of conversion information for Access 2000 =

Article ID: 208769

Article Last Modified on 1/23/2006

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q208769



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

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



For a Microsoft Access 97 version of this article, see 160949.



SUMMARY
When you use Microsoft Access 2000 to open a database that was created in an earlier version of Microsoft Access, in most cases, the database is converted without difficulty. However, there are circumstances when objects and code in the older database may conflict with new features in Access 2000. Before you convert a database to Microsoft Access 2000, you should review the available information about conversion and compatibility so that you can be familiar with the issues that may arise. This article lists many of the resources available about conversion and compatibility.



MORE INFORMATION
Microsoft Access 2000 has a new feature that is not available in earlier versions of Access. In Access 2000, you can convert an Access 2000 database back to the Access 97 file format. For more information about converting an Access 2000 database back to Access 97, click Microsoft Access Help on the Help menu, type convert an Access 2000 database to Access 97 in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.

Conversion White Paper
The most comprehensive single source of information about converting databases to Microsoft Access 2000 is the Microsoft Access 2000 Conversion White Paper. The white paper includes the following topics:
 * Overview
 * Converting a Database
 * Converting Microsoft Access 97 Databases
 * Converting Microsoft Access 95 Databases
 * Converting Microsoft Access 2.0 Databases
 * Issues Encountered When Saving as a Prior Version

For additional information about how to obtain the Microsoft Access 2000 Conversion White Paper, click the article number below to view the article in the Microsoft Knowledge Base:

237313 ACC2000: Conversion White Paper Available in Download Center

Help Topics
For more information about conversion and compatibility issues, click Microsoft Access Help on the Help menu, type conversion compatibility in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.

The "Conversion and Compatibility Issues" Help topic contains the following links:
 * Convert a Database
 * Convert a Secured Database from a Previous Version of Microsoft Access
 * Convert Library Databases and Add-ins
 * What's New for Developer's: Overview
 * Convert Access Basic Code to Visual Basic
 * Convert Code That Calls a DLL
 * Macro Actions and Methods of the DoCmd Object
 * Convert SendKeys Key Combinations
 * Style for Intrinsic Constants
 * Scoping and Object-Naming Compatibility
 * DAO Object Library Compatibility
 * Examples of Converting DAO Code

For more information about troubleshooting the conversion of a previous-version database, click Microsoft Access Help on the Help menu, type troubleshoot converting previous version in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.

The "Troubleshoot Converting an Access Database" Help topic contains the following links:

Converting any previous-version database


 * An identifier causes an error
 * My code can't compile
 * Time values in my query criteria return different results

Converting a Microsoft Access version 2.0 database


 * My converted Microsoft Access version 2.0 report has different margins
 * A procedure causes an error
 * I receive an out-of-memory error when converting a large database
 * My 16-bit API calls do not convert
 * My custom controls do not convert
 * I receive an error that a table exceeds the limit of 32 indexes
 * I receive an ODBC error when opening a form or report in a converted database

Converting a Microsoft Access 2000 database to Microsoft Access 97


 * I receive a message that my computer is missing at least one of the Access 97 object libraries

Microsoft Access 2000 Readme File
Another good source of information is the Microsoft Access 2000 Readme file (Acread9.txt). This file is installed by default in the C:\Program Files\Microsoft Office\Office folder. The readme file contains the following topics related to conversion and compatibility:
 * Compatibility Library
 * Turning On Name AutoCorrect in a Converted Access Database

