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

Chapter 22. Upsizing Jet Applications to... > Preparing to Upsize Your Jet Applica...

Preparing to Upsize Your Jet Applications

There are two basic approaches to increasing the probability of a fully successful upsizing operation:

  • Trial and error— Run the Wizard early and often to determine the scope of the additional effort necessary to upsize your Jet application successfully. If you have very large tables, you can use the structure-only option to minimize upsizing time. Read the Upsizing Wizard's report, make the changes necessary to upgrade missing objects, and try again.

  • Planned migration— Make changes to the Jet tables, queries, and application objects to minimize the likelihood of upsizing problems. For example, convert your VBA code that uses Data Access Objects (DAO) to ActiveX Data Objects (ADO) that use the OLE DB data provider for Jet. Thoroughly test your changes


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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