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 ...

Get Special Edition Using Access 97, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.