Microsoft KB Archive/241743

Knowledge Base

ACC2000: "Access 2000 Upsizing Tools" White Paper Available in Download Center

Article ID: 241743

Article Last Modified on 1/26/2005

---

APPLIES TO

• Microsoft Access 2000 Standard Edition

---

This article was previously published under Q241743

For a Microsoft Access 2002 version of this article, see 294407.

SUMMARY

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

The following file is available for download from the Microsoft Download Center:

Download Upsize00.exe now

The Upsize00.exe file contains the following file:

   Upsize00.doc  A Microsoft Word document
   Readme.txt    The Readme file
                

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 2000 Upsizing Tools white paper contains the following topics: INTRODUCTION VERSION SUPPORT

• SQL Server 7.0
• MSDE
• SQL Server 6.5
• Unsupported Versions of SQL Server

NEW FEATURES AND ENHANCEMENTS

• Creating New Client/Server Applications
• Unattended Upsizing
• Silent Errors
• Tables Automatically Renamed
• Automatic Log Truncation
• Linked Tables Can Be Upsized
• Error Message Text for Triggers
• Wizard Defaults to "Create New Database"
• Hidden Objects Are Not Upsized
• Upsizing Report Improvements
• Better Error Details
• Automatic Snapshot Report
• Naming Rules

THE UPSIZING PROCESS PREPARING TO UPSIZE

• Security
• Jet Security Settings Not Migrated
• Permissions Necessary to Upsize
• Tables
• DefaultValue and ValidationRule Properties
• ValidationText Property
• The Format and InputMask Properties
• The Caption Property
• The AllowZeroLength Property
• Required
• Indexed
• Data Types
• Lookup Fields
• Queries
• Queries That Are Not Upsized
• Properties That Are Not Upsized
• Upsizing Queries with Functions
• How Queries Are Upsized
• Queries That Are Upsized But That Won't Run
• Forms
• Properties
• How Forms Are Upsized
• Form RecordSource Property
• The OrderBy Property
• The Filter Property
• Data-Bearing Controls
• Charts
• Reports
• OrderByOn and FilterOn Properties
• Client/Side Filtering and Grouping
• Modules
• Data Access Objects
• Miscellaneous Issues
• Naming Issues
• Upsizing Logic

RUNNING THE UPSIZING TOOLS

• Gathering Necessary Information
• Running the Wizard
• Existing or New Database?
• Select Tables to Upsize
• Choosing Which Table Attributes to Upsize
• Modifying the Application
• Finishing

EXAMINING THE UPSIZING REPORT RECREATING OBJECTS ON SQL SERVER OR MSDE

• Tables
• Queries

LEARNING MORE ABOUT SQL SERVER 7 AND MSDE

Additional query words: upsize wizard

Keywords: kbhowto kbdownload kbgraphxlinkcritical kbfile KB241743

---

Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.