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

Chapter 31. Migrating Access 9x Applicat... > Understanding the .mdb File Upgrade ...

Understanding the .mdb File Upgrade Process

Each version of Access—1.0, 1.1, 2.0, 95, 97, and 2000—has a different database file structure at the binary (byte) level. The differences between 16-bit .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, with the exception of Access 2000, one-way conversion during the upgrade process.

Access 2000 lets you convert data .mdbs from Access 2000 (Jet 4.0) to Access 97 (Jet 3.5x) format. You also can convert Access 2000 application .mdbs that don't contain objects—such as Data Access Pages (DAP)—or references—to ActiveX Data Objects (ADO and ADOX) or Data Access Objects (DAO) 3.6—that are missing in Access 97.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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