ACCESS2000升迁向导“溢出”错误处理方法

以下为引用的内容：

ACC2000: "Overflow" Error Message When You Try to Upsize to SQL Server 2000The information in this article applies to:Microsoft ACCESS 2000 中.国站长站

This article was previously published under Q272384 Moderate: Requires basic macro, coding, and interoperability skills. ^com

This article applies to a Microsoft Access database (.mdb) and to a Microsoft ACCESS project (.adp). 中国.站.长站

SYMPTOMSWhen you try to upsize a Microsoft ACCESS 2000 database to Microsoft SQL Server 2000, you may receive the following error message: Www@@com

Overflow RESOLUTIONOffice 2000 Service Pack 3To correct this problem, obtain the latest service pack for Microsoft Office 2000. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

276367 OFF2000: How to Obtain the Latest Office 2000 Service Pack

IMPORTANT: Before you install Microsoft Office 2000 Service Pack 3 (SP-3), you must have Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a) installed first. For additional information about how to obtain Office 2000 Service Release 1/1a (SR-1/SR-1a), click the following article number to view the article in the Microsoft Knowledge Base: Www~~com

245025 OFF2000: How to Obtain and Install Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a) ACCESS 2000 and SQL Server 2000 Readiness Update 中.国站长站

ACCESS 2000 and SQL Server 2000 Readiness UpdateMicrosoft has created the "ACCESS 2000 and SQL Server 2000 Readiness Update" to correct this issue. Follow the steps below to obtain and install this update: Make sure you have Office (or ACCESS) 2000 SR-1. You can obtain the Office 2000 SR-1/SR-1a update the from the following Microsoft Web site: .com

http://office.microsoft.com/downloads/2000/O2kSR1DDL.aspx

Rename the following files by changing the extension from .mde to .old: 中.国站长站

Acwzlib.mdeAcwzmain.mdeAcwztool.mde Www^^com

For the English version of Office, by default, these files are located in the C:\Program Files\Microsoft Office\Office\1033 folder. 中国站长.站

Download the "ACCESS 2000 and SQL Server 2000 Readiness Update" from the following Microsoft web site: [中国站长站]

http://office.microsoft.com/downloads/2000/Accsql.aspx Www..com

Make a note of the folder to which you download this update. Www..com

Double-click the Accsql.exe file, which you downloaded in step 2, to install the "ACCESS 2000 and SQL Server 2000 Readiness Update."IMPORTANT: After installing this update, you must use Mixed Mode Authentication (Windows Authentication and SQL Server Authentication) to upsize your database by using a SQL Server login. Windows Authentication mode is not supported. If Windows Authentication mode is set when you upsize, your tables or queries may be skipped. 中国站长_站,为中文网站提供动力

NOTE: If you install SQL Server with Windows Authentication Mode set, and later change the Security Authentication to Mixed Mode Authentication, the built-in system administrator (SA) login's password may be blank. After enabling SQL Server security you should immediately create a password for the 'SA' login to help prevent unauthorized ACCESS to your SQL Server. For additional information, click the article number below to view the article in the Microsoft Knowledge Base: Www^^com

274773 BUG: If You Change Windows Security to Windows/SQL Security the SA Password is Blank ^com

After SQL Server Authentication is enabled, you can then use the built-in 'SA' account or create a new SQL Server account for upsizing. If you are using a new account, be sure to set the "Server Role" to 'Database Creators'. For more information, see SQL Server Books Online. 站.长.站

Workaround the Error Without the Readiness UpdateYou can use one of the following workarounds instead of installing the "ACCESS 2000 and SQL Server 2000 Readiness Update": Upsize your data to SQL Server 7.0 or Microsoft Data Engine (MSDE) first. You can then convert the SQL Server 7.0 or MSDE database to SQL Server 2000. You can accomplish the conversion in several ways: Use the Data Transformation Services Wizard (DTS) to move the data from SQL Server 7.0 or MSDE to SQL Server 2000.Use the "Copy Database Wizard" in SQL Server 2000 to move the data. Detach the database from SQL Server 7.0 or MSDE, and then attach it to SQL Server 2000. _com

CAUTION: Once you have converted the database to the SQL Server 2000 format, you will not be able to reattach the database to SQL Server 7.0. @com

For more information about upgrading to SQL Server 2000, please see the following article in the Microsoft Knowledge Base:For additional information about upgrading to SQL Server 2000, click the article number below to view the article in the Microsoft Knowledge Base:

标签：

版权申明：本站文章部分自网络，如有侵权，请联系：west999com@outlook.com
特别注意：本站所有转载文章言论不代表本站观点，本站所提供的摄影照片，插画，设计作品，如需使用，请与原作者联系，版权归原作者所有