List of conversion information for Access 2000 (208769)


The information in this article applies to:

  • Microsoft Access 2000
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 <I>Microsoft Access 2000 Conversion White Paper</I>, 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

REFERENCES

For additional information about conversion issues in Microsoft Access 2000, click the article numbers below to view the articles in the Microsoft Knowledge Base:

190637 ACC2000: Status Bar Says Ready Before Database Is Fully Converted

198986 ACC2000: Converting to Access 97 Creates Unsecured Database

202479 ACC2000: Unexpected Characters Appear When You Convert Databases That Have Non-U.S. English Characters

208192 ACC2000: Errors Converting or Importing with 754 or More Control

208645 ACC2000: Troubleshooting Tips for Conversion Issues in Access 2000

210115 ACC2000: How to Convert API Calls from 16-bit to 32-bit

224340 ACC2000: Error Message: There Were Compilation Errors During the Conversion or Enabling Of This Database...

225946 ACC2000: Corrupted VBA Project Error When You Try to Convert a Database

225949 ACC2000: Error Converting a Database with a Large Number of Forms That Have Modules

237363 ACC2000: Converting Database Containing Cyrillic Fonts Causes Text to Be Unreadable

225962 ACC2000: By Default, New Access Databases Do Not Include Reference to Microsoft DAO Object Library

Modification Type:MinorLast Reviewed:1/23/2006
Keywords:kbconvert kbinfo kbhowto KB208769
©2004 Microsoft Corporation. All rights reserved.