This article applies only to a Microsoft Access database (.mdb) or a Microsoft Office Access 2007 database (.accdb).
Conversion ErrorsTo see where the error or errors occur, compile all modules in the converted database.
Note For compilations that do not have any errors, you may still have to manually change some syntax in the database after conversion.
To compile all modules in a converted database, follow these steps:
- Open the converted database in the new version of Microsoft Access.
- Open a module in Design view.
- On the Debug menu, click Compile <Database Name>.
Incompatibilities with Certain ObjectsIf the conversion process seems to stop, takes a long time to finish, or displays an error that prevents the new database from being created, you can create a new database in Access 2002 or in later versions. You can then import objects (individually or grouped) from the database in the earlier version.
Importing objects into a new database has two benefits:
- You can speed the conversion process by importing groups of objects. If you have a large database, the conversion process may be slow or may appear to cause your computer to stop responding. Importing groups of objects requires less memory and, in some cases, may be faster.
- You can determine which objects are incompatible with Access 2002 or with later versions. If an object cannot be imported, you know to examine it more closely for a potential incompatibility. If an object is imported successfully, it is automatically converted to the new version.
NOTE: In rare instances, corruption in an object may cause incompatibility with the later version of Access. If you suspect corruption, do not import that object. Instead, re-create it in the later version of Access. If the object is a Visual Basic for Applications procedure, try copying the text to a Notepad file. Then, copy it from that file later and paste it into a new module in the later version of Access.
- In Access 2002 or in Access 2003, create a new Access database.
- On the File menu, point to Get External Data, and then click Import.
- In the Import dialog box, click Microsoft Access in the Files of type box.
- Click the arrow to the right of the Look In box, select the drive and folder where the Microsoft Access database (.mdb) that you want to import is located, and then double-click the icon of the database.
- Click one or more objects to import. For example, you may want to import the objects in groups of 20.
- Click OK to import the selected objects.
- Repeat steps 2 through 6 until you have imported all the objects into the new database.
- In Access 2007, create a new Access database.
- Click the External Data tab, and then click Access in the Import group.
- In the Get External Data – Access Databasedialog box, click Browse to select the Microsoft Office Access 2007 database (.accdb), click Open, and then click
- In the Import Objects dialog box, select the objects that you want to import, and then click OK.
- Repeat steps 2 through 4 until you have imported all the objects into the new database.
Errors in Code in the Earlier VersionTo reduce the number of errors that may occur during the conversion process, recompile all modules in the earlier version database. Then correct any errors before you convert the database.
ID do Artigo: 324350 - Última Revisão: 30 de out de 2008 - Revisão: 1