• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part 8: Appendix > Converting from a Previous Release of Microsoft Access

Converting from a Previous Release of Microsoft Access

Microsoft Office Access 2003 (version 11 of Access) can work with the data and tables in a database file created by Access version 2, version 7 (Access for Windows 95) version 8 (Access 97), version 9 (Access 2000), and version 10 (Access 2002). Depending on the complexity of the application, you might be able to open and run a version 2, 7, or 8 database application with version 11, but you won’t be able to modify any of the objects in the database. You can open a version 9 or version 10 database with version 11 and modify any of the objects in the database.

You can convert a version 2, version 7, or version 8 database file to either the Access 2000 format (version 9) or the Access 2002–2003 format (versions 10 and 11). First, make sure all Access Basic or VBA modules are compiled in your earlier version database. For version 2 databases, this means you must open each form and report module individually and compile and save the module. Start Access 2003, and choose Database Utilities from the Tools menu. Choose Convert Database from the submenu and then choose To Access 2000 File Format or To Access 2002–2003 File Format. (Access 2003 also includes a utility to convert a 2000 or 2002–2003 format database back to version 8.) In the Database to Convert From dialog box, select the earlier version file that you want to convert. Access opens the Convert Database Into dialog box. You must specify a different file name or location for your converted database because Access won’t let you replace your previous version file directly.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint