Help and Support

List of conversion information for Access 2000

Article ID:208769
Last Review:January 23, 2006
Revision:3.1
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 (http://support.microsoft.com/kb/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.

Back to the top

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 (http://support.microsoft.com/kb/237313/EN-US/) 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

Back to the top

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 (http://support.microsoft.com/kb/190637/EN-US/) ACC2000: Status Bar Says Ready Before Database Is Fully Converted
198986 (http://support.microsoft.com/kb/198986/EN-US/) ACC2000: Converting to Access 97 Creates Unsecured Database
202479 (http://support.microsoft.com/kb/202479/EN-US/) ACC2000: Unexpected Characters Appear When You Convert Databases That Have Non-U.S. English Characters
208192 (http://support.microsoft.com/kb/208192/EN-US/) ACC2000: Errors Converting or Importing with 754 or More Control
208645 (http://support.microsoft.com/kb/208645/EN-US/) ACC2000: Troubleshooting Tips for Conversion Issues in Access 2000
210115 (http://support.microsoft.com/kb/210115/EN-US/) ACC2000: How to Convert API Calls from 16-bit to 32-bit
224340 (http://support.microsoft.com/kb/224340/EN-US/) ACC2000: Error Message: There Were Compilation Errors During the Conversion or Enabling Of This Database...
225946 (http://support.microsoft.com/kb/225946/EN-US/) ACC2000: Corrupted VBA Project Error When You Try to Convert a Database
225949 (http://support.microsoft.com/kb/225949/EN-US/) ACC2000: Error Converting a Database with a Large Number of Forms That Have Modules
237363 (http://support.microsoft.com/kb/237363/EN-US/) ACC2000: Converting Database Containing Cyrillic Fonts Causes Text to Be Unreadable
225962 (http://support.microsoft.com/kb/225962/EN-US/) ACC2000: By Default, New Access Databases Do Not Include Reference to Microsoft DAO Object Library

Back to the top


APPLIES TO
Microsoft Access 2000 Standard Edition

Back to the top

Keywords: 
kbconvert kbinfo kbhowto KB208769

Back to the top

Article Translations

 

Related Support Centers

Other Support Options

  • Need More Help?
    Contact a Support professional by Email, Online or Phone.
  • Customer Service
    For non-technical assistance with product purchases, subscriptions, online services, events, training courses, corporate sales, piracy issues, and more.
  • Newsgroups
    Pose a question to other users. Discussion groups and Forums about specific Microsoft products, technologies, and services.