Microsoft KB Archive/225874

= ACC2000: Changing DataType or Length May Cause Data Loss or Truncation in Project =

Article ID: 225874

Article Last Modified on 6/24/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q225874





Novice: Requires knowledge of the user interface on single-user computers.

This article applies only to a Microsoft Access project (.adp).



SYMPTOMS
When you change the DataType or Length property of a table field in a Microsoft Access project, your data may be lost or truncated without warning.



CAUSE
The data in an Access project is stored directly on either a SQL Server or the Microsoft Date Engine (MSDE). SQL Server and MSDE do not return an error when a field change will delete or truncate existing data.



RESOLUTION
Data that is deleted or truncated in this manner is lost. The only way to recover the original data at this point would be to restore the original field properties, and then to recover the data from a backup you made before the data was lost. If you do not have access to a backup, you can manually re-enter the data that was lost or truncated.



STATUS
Microsoft has confirmed that this is a problem in Microsoft Access 2000 Projects (*.adp).



Steps to Reproduce Behavior

 * 1) Open the sample Access project NorthwindCS.adp.
 * 2) In the Database window, click Tables under Objects.
 * 3) Select the Customers table, and then on the Edit menu, click Copy.
 * 4) On the Edit menu, click Paste.
 * 5) In the Paste Table As dialog box, type TestTable as the Table name, click Data and Structure, and then click OK.
 * 6) Open the TestTable table in Design view.
 * 7) Change the Length property of the CompanyName column to 10.
 * 8) Save the changes; click Yes in the Save confirmation dialog box.
 * 9) Open the TestTable table in Datasheet view.

Note that the entries in the CompanyName column are truncated at 10 characters.

Additional query words: pra

Keywords: kbbug kbclientserver kbpending KB225874

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.