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

Chapter 32. Migrating Access 2.0 and Acc... > Using Access 1.x and 2.0 Data .mdb F...

Using Access 1.x and 2.0 Data .mdb Files with Access 97

If you use the recommended split-database method (storing application objects and data objects in two separate .mdb files), you can convert your Access 1.x or 2.0 application .mdb file to Access 97, but leave the data .mdb as a version 1.x or 2.0 .mdb file. Users of 16-bit Access, Access 95, and Visual Basic 3.0, 4.0, or 5.0 can share the linked data .mdb files. When you attach tables contained in Access 1.x, 2.0, or 95 .mdb files, you don't receive a warning message. You cannot use Access 95 features, such as Briefcase replication, with .mdb files created with Access 2.0 or earlier.

Note

It is a relatively easy process to split Access 1.x or 2.0 applications into separate data and application .mdb files. (Access 95 and 97 include the Database Splitter Add-In that automates this process; prior versions of Access do not offer this feature.) In your prior version of Access, create a new .mdb file, then import the tables from your existing .mdb file. Verify that the imported tables contain valid data, then delete the tables from your original .mdb file. Move the table to its final location, such as on a network server, and then attach the tables to the application .mdb file.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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