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

Part 7: Programming and Converting Acces... > Migrating Access 2.0 and Access 95 A...

Chapter 32. Migrating Access 2.0 and Access 95 Applications to Access 97

Each version of Access—1.0, 1.1, 2.0, 95, and 97—has a different database file structure at the binary (byte) level. The differences between .mdb files created with versions 1.0 and 1.1 were relatively minor; thus, you could use the Compact feature of Access to convert version 1.0 .mdbs to version 1.1, or vice versa. The file formats of later versions of Jet databases are sufficiently different to require one-way conversion during the upgrade process.

The Convert Database process is not reversible; once you've converted a database to the Access 97 (version 8.0) .mdb structure of Jet 3.5, you can't convert it back to version 7.0 (Jet 3.0) or 2.0 (Jet 2.x). However, you can open and use version 2.0 .mdb and Access 95 .mdb files with Access 97. Many Access 2.0 users were forced to forego the transition to Access 95 because of limited deployment of Windows 95 by large organizations. Consequently, this chapter begins by addressing the ramifications of continuing to use version 2.0 .mdb files with Access 97 and then explains how to convert your existing .mdb files to Access 95's 32-bit .mdb structure. The chapter concludes with a discussion of the relatively minor changes involved in converting Access 95 files to Access 97 format.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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