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

Chapter 31. Upgrading Access 9x and 2000... > Understanding the .mdb File Upgrade ...

Understanding the .mdb File Upgrade Process

Each version of Access—1.0, 1.1, 2.0, 95, 97, 2000, and 2002—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 and 2002, one-way conversion during the upgrade process.

Tip from

Access 2002 uses the 2000 and 2002 version of Jet 4.0 files interchangeably. Only very large Access front-end applications benefit by upgrading from the default Access 2000 (version 9.0) .mdb structure and the new 2002 version (10.0). Version 10.0 supports a few new VBA-related properties and methods that aren't available in version 9.0.


Unless you encounter slow compilation of VBA code in the Access 2000 version or need to use version 10.0's VBA extensions, there's no reason to change the .mdb format to 10.0. The term Access 2002 in this chapter means the name of the application, not the .mdb or .adp file format. Jet 4.0 means either Access 2000 or 2002 file format.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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