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

Chapter 30. Programming Combo and List B... > Converting Your Combo Box Form to an...

Converting Your Combo Box Form to an Access Data Project

Access 2002's Upsizing Wizard (AUW) does a much better job of converting Jet applications to Access Data Projects (ADP) than the Access 2000 version. In most cases, however, the AUW can't upsize complex Jet-based forms to forms that are operable in ADP. For instance, the AUW doesn't translate to Transact-SQL (T-SQL) the Jet-specific SQL statements that serve as the Record Source property of bound forms and reports, and the Row Source property value of controls. The forms you created in the preceding sections provide good examples of the problems you encounter when upsizing forms to ADP. Among the issues you encounter is the Wizard's insistence on upsizing the Jet application's local or linked tables to an SQL Server database, even if the tables already exist in one of your databases.

→ For an explanation of some of the limitations of the AUW, see “Upsizing with the Trial-and-Error Approach”.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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