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

Chapter 32. Upgrading Access 97 and 2000... > Understanding the .mdb File Upgrade ...

Understanding the .mdb File Upgrade Process

Access 2003 is the first Access release that doesn’t introduce a new Jet database format. Prior to Access 2003, each version of Access—1.0, 1.1, 2.0, 95, 97, 2000, and 2002—had 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 the Access 2000 and 2002 formats, one-way conversion during the upgrade process.

Tip

Access 2003 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 2002 version (10.0). Version 10.0 supports a few 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 2003 in this chapter means the application version, not the .mdb or .adp file format. Access 2002+ refers to features that remain the same in Access 2002 and 2003. 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