ACCESS2000升遷向導“溢出”錯誤處理方法_Access數據庫教程

      編輯Tag賺U幣
      教程Tag:暫無Tag,歡迎添加,賺取U幣!

      推薦:完美表格:使用表層屬性來提高效率
      建立Access表格的方式能夠導致它們性能及可信賴性方面的不同。以下將簡單地提出一些方法,讓你知道如何有效地運用Access的特性,例如表層屬性、數據類型以及索引,讓你的表格設計能夠達到最為理

      以下為引用的內容:

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

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

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


      SYMPTOMS
      When you try to upsize a Microsoft ACCESS 2000 database to Microsoft SQL Server 2000, you may receive the following error message:

      Overflow
      RESOLUTION
      Office 2000 Service Pack 3
      To 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:

      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 Update
      Microsoft 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:

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


      Rename the following files by changing the extension from .mde to .old:

      Acwzlib.mde
      Acwzmain.mde
      Acwztool.mde

      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

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


      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:

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

      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 Update
      You 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.

      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.

      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:

      261334 INF: Frequently Asked Questions - SQL Server 2000 - Upgrade


      Use the Data Transformation Services Wizard (DTS) to move the data from ACCESS to SQL Server 2000. For more information about this process, please see the following article in the Microsoft Knowledge Base article: For additional information about this process, click the article number below to view the article in the Microsoft Knowledge Base:

      250616 ACC2000: How to Use Data Transformation Services (DTS) to Export Data from a Microsoft ACCESS Database to a SQL Server Database


      STATUS
      Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
      MORE INFORMATION
      If you previously ran the Upsizing wizard to upsize an ACCESS 2000 database to SQL Server 7.0, you may encounter another error after applying this update. For additional information about this error message, click the article number below to view the article in the Microsoft Knowledge Base:

      288300 ACC2000: Error: "Microsoft Access can't find the wizard..." After Applying the ACCESS 2000 and SQL Server 2000 Readiness Update


      Steps to Reproduce Behavior
      Open the sample database Northwind.mdb.
      On the Tools menu, point to Database Utilities, and then click Upsizing Wizard.
      On the first page of the wizard, accept the default choice, and then click Next.
      On the second page of the wizard, select your SQL Server 2000 server, type an appropriate logon name and password, and then click Next.
      Note that you receive the "Overflow" error message, and that you are then returned to the wizard. The database is not upsized.
      REFERENCES
      For information about applying the Access 2000 and SQL Server 2000 Readiness Update to an administrative installation of Office, click the article number below to view the article in the Microsoft Knowledge Base: For additional information about how you can apply the ACCESS 2000 and SQL Server 2000 Readiness Update to an administrative installation of Office, click the article number below to view the article in the Microsoft Knowledge Base:

      287484 OFF2000: Administrative Update Available for ACCESS 2000 and SQL Server 2000 Readiness

      分享:當Access文件大于指定的大小時就自動壓縮
      適用 ACCESS2000及以后版本 首先在公共模塊添加如下函數: 以下為引用的內容: Public Function AutoCompactCurrentProject() Dim

      來源:模板無憂//所屬分類:Access數據庫教程/更新時間:2008-08-22
      相關Access數據庫教程