ACC: Troubleshooting Tips for Conversion Issues in 95 and 97

ID: Q141296


The information in this article applies to:


SUMMARY

When you convert a Microsoft Access version 1.x or 2.0 database to a Microsoft Access 7.0 or Microsoft Access 97 database, the conversion process may display a warning message or stop altogether because of an incompatibility with new features and enhancements. This article discusses general troubleshooting tips for the unusual case when Microsoft Access cannot convert a database successfully.


MORE INFORMATION

Compile Errors

If conversion creates a database, but you receive an error message, such as "There were compilation errors during the conversion or enabling of this database," you should compile all modules in the converted database. The converted database may have changes in syntax from version 1.x or 2.0 that you must manually change. In rare instances, the conversion utility may fail to convert some Access Basic code to Visual Basic for Applications code. For example, it may fail to modify a DoCmd statement

   DoCmd OpenForm "MyForm" 

into a method of the DoCmd object:

   DoCmd.OpenForm "MyForm" 

To compile all modules in a converted database, follow these steps:
  1. Open the converted database in the new version of Microsoft Access.


  2. Open a module in Design view.


  3. On the Debug menu (the Run menu in Microsoft Access 7.0), click Compile All Modules.


As Microsoft Access compiles your code, it will stop at any line that contains an error. Then you can modify the syntax to resolve the compilation error.

Import Objects

If the conversion process seems to stop, takes a long time to complete, or displays an error that prevents the new database from being created, you can create a new database in Microsoft Access 7.0 or Microsoft Access 97 and import objects (individually or grouped) from the version 1.x or 2.0 database.

Importing objects into a new database has two benefits:
To use the Import command instead of the Convert Database command, follow these steps:
  1. Create a new Microsoft Access 7.0 or Microsoft Access 97 database.


  2. On the File menu, click Get External Data, and then click Import.


  3. In the Import dialog box, make sure to select Microsoft Access (.mdb) in the Files Of Type box.


  4. Click the arrow to the right of the Look In box, select the drive and folder where the Microsoft Access database (.mdb) you want to import is located, and then double-click the database's icon.


  5. Click one or more (up to 20) objects to import.


  6. Click OK to import the selected objects.


  7. Repeat steps 2-6 until all the objects are imported into the new database.


Reduce Errors

To help reduce errors during the conversion process:


REFERENCES

For more information about converting databases that use 16-bit application programming interface (API) calls, please see the following article in the Microsoft Knowledge Base:

Q147781 ACC: How to Convert API Calls from 16-bit to 32-bit

For more information about database conversion and compatibility, type "conversion and compatibility" in the Office Assistant, click Search, and then click to view "Conversion and Compatibility Issues."

For information about issues related to converting a database, read the "Conversion and Compatibility" section of the Acread80.wri file in your Microsoft Access 97 folder (or in the Acreadme.txt file in your Microsoft Access 7.0 folder.)


Keywords          : kbusage 
Version           : 7.0 97
Platform          : WINDOWS 
Issue type        : 

Last Reviewed: April 13, 1999