"Access 2002 Upsizing Tools" white paper is available in Download Center (294407)



The information in this article applies to:

  • Microsoft Access 2002

This article was previously published under Q294407
Moderate: Requires basic macro, coding, and interoperability skills.

This article applies only to a Microsoft Access database (.mdb).

For a Microsoft Access 2000 version of this article, see 241743.

SUMMARY

The Access 2002 Upsizing Tools white paper (Upsize02.doc) describes how to use the Upsizing Tools included in Access 2002. Use the document as an aid in preparing to migrate the data in an Access 2002 database to SQL Server, creating a client/server application from an Access 2002 database, and troubleshooting errors in the upsizing process itself.

The following file is available for download from the Microsoft Download Center:
The Upsize02.exe file contains the following file:
   Upsize02.doc  A Microsoft Word document
				
For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base:

119591 How to Obtain Microsoft Support Files from Online Services

Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help to prevent any unauthorized changes to the file.

MORE INFORMATION

The Access 2002 Upsizing Tools white paper contains the following topics:
  • INTRODUCTION
    • Supported Versions
  • FEATURES AND ENHANCEMENTS
    • Creating New Client/Server Applications
    • Unattended Upsizing
      • Tables Automatically Renamed
      • Automatic Log Truncation
    • Linked Tables Can Be Upsized
    • Error Message Text for Triggers
    • Hidden Objects Are Not Upsized
    • Upsizing Report
      • Error Details
      • Automatic Snapshot Report
  • THE UPSIZING PROCESS
  • PREPARING YOUR DATABASE FOR UPSIZING
    • Jet Security Settings Not Migrated
    • Permissions Necessary to Upsize
    • User Defined VBA Function Are Not Upsized
    • Not All Queries Can Be Re-created on SQL Server
  • UPSIZING TABLES
    • Migration of Jet Extended Properties
    • Table and Field Validation Migration
    • Default Value and Validation Rule Properties
      • ValidationText Property
      • Caption Property
      • AllowZeroLength Property
      • Required Property
      • Indexed Property
    • Data Types
      • Unicode Data Types
    • Lookup Fields
    • Relation Migration Of Foreign Keys
  • UPSIZING QUERIES
    • Queries That Are Not Upsized
    • Query Extended Properties
    • Upsizing Queries That Contain Access VBA Functions
    • How Queries Are Upsized
    • Select Queries
    • Union Queries
    • Action Queries
    • Queries That Are Upsized But May Not Run
      • Update Queries Based on Sorted Queries
      • UniqueRecords Property May Not Upsize
      • Upsized Make-Table Queries
      • Upsized Append Queries
  • UPSIZING FORMS
    • Properties
    • How Forms Are Upsized
    • Record Source with Parameters
    • Row Source with Parameters
    • Converting Form Filter Property to Server Filter
  • UPSIZING REPORTS
  • MISCELLANEOUS ISSUES
    • Upsizing Modules
    • Upsizing Data Access Objects
    • Upsizing Charts
    • Naming Issues
    • Structure Only
  • RUNNING THE UPSIZING WIZARD
    • Gathering Necessary Information
    • Running the Wizard
    • Step 1: New or Existing SQL Server Database?
    • Selecting a New SQL Server Database
    • Selecting an Existing SQL Server Database
    • Step 2: Exporting Tables to SQL Server
    • Step 3: Table Attributes and Other Options
    • Indexes
    • Clustered and Non-Clustered Indexes
    • Validation Rules
    • Table Relationships
    • Timestamps
    • Structure Only
    • Step 4: Application Changes
      • Create a New Access Client/Server Applications
      • Link SQL Server Tables to Existing Applications
      • No Application Changes
    • Step 5: Opening the MDB or ADP
    • The Upsizing Report
  • FOR MORE INFORMATION

Modification Type:MinorLast Reviewed:8/25/2004
Keywords:kbdownload kbfile kbgraphxlinkcritical kbhowto KB294407