Microsoft KB Archive/294407

= &quot;Access 2002 Upsizing Tools&quot; white paper is available in Download Center =

Article ID: 294407

Article Last Modified on 8/25/2004

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-



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:

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

Additional query words: inf

Keywords: kbhowto kbdownload kbgraphxlinkcritical kbfile KB294407

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.