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

Article translations Article translations
Article ID: 294407 - View products that this article applies to.
This article was previously published under Q294407
This article has been archived. It is offered "as is" and will no longer be updated.
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.
Expand all | Collapse all

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:
Collapse this imageExpand this image
DOWNLOAD
Download Upsize02.exe now
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
Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.

Properties

Article ID: 294407 - Last Review: October 24, 2013 - Revision: 2.0
Applies to
  • Microsoft Access 2002 Standard Edition
Keywords: 
kbnosurvey kbarchive kbdownload kbfile kbgraphxlinkcritical kbhowto KB294407

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com