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

Article translations Article translations
Article ID: 241743 - View products that this article applies to.
This article was previously published under Q241743
This article has been archived. It is offered "as is" and will no longer be updated.
For a Microsoft Access 2002 version of this article, see 294407.
Expand all | Collapse all

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:
Collapse this imageExpand this image
DOWNLOAD
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

Properties

Article ID: 241743 - Last Review: October 25, 2013 - Revision: 4.0
Applies to
  • Microsoft Access 2000 Standard Edition
Keywords: 
kbnosurvey kbarchive kbdownload kbfile kbgraphxlinkcritical kbhowto KB241743

Give Feedback

 

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