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

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:
The Upsize00.exe file contains the following 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: 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.

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