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

Chapter 22. Upsizing Jet Applications to... > Running the Jet Crosstab Upsizer

Running the Jet Crosstab Upsizer

The Visual Basic 6.0 Crosstab Upsizer program (Crosstab.exe), which you install from the \Seua11\Crosstab folder of the accompanying CD-ROM, automates generation of the view or function and stored procedure that are required to emulate a Jet crosstab query. The program connects to the .mdb file that contains the crosstab queries and the upsized SQL Server database. You must install Crosstab.exe and its associated files on a computer running Access 2003.


Note

You can learn more about the Crosstab Upsizer and download its source code from Visual Studio Magazine’s “Upsize Jet Crosstab Queries” article at http://www.fawcette.com/archives/premier/mgznarch/vbpj/2001/10oct01/sqlpro0110/rj0110/rj0110-1.asp.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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