Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Insertions and updates in C++ Microsoft Jet DAO MFC applications may not work on a computer that is running Windows Vista Service Pack 1 or Windows Server 2008
| Article ID | : | 952337 |
| Last Review | : | June 9, 2008 |
| Revision | : | 2.0 |
SYMPTOMS
In a C++ Microsoft Jet DAO MFC (CDao) application, insertions and updates may not work on a computer that is running Windows Vista Service Pack 1 (SP1) or Windows Server 2008. Additionally, you may receive the following error message:
The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data.
Back to the top
CAUSE
This problem occurs when all the following conditions are true:
| • | The application is written in Microsoft Visual C++ and uses the CDao classes to access a Microsoft Jet database data source.
|
| • | The Use Multi-Byte Character Set value is set for the Character Set project option.
Or, no value is set for this option.
Note This issue does not occur if the UNICODE value is set for the Character Set project option. |
| • | The data that the application is inserting or updating was retrieved from a fixed-length defined Text column.
|
| • | The source Text column contains data that is the maximum length that the column allows. For example, a Text(10) column contains a value of 1234567890.
|
| • | Successive insertions or updates occur from the original variable that is returned from the CDaoRecordset object.
|
| • | The target table column is one of the following columns:| • | The same column from which the original data was retrieved | | • | Another fixed-length column that is defined as a Text column of the same size |
|
Back to the top
RESOLUTION
To resolve this problem, apply the hotfix that is described in Microsoft Knowledge Base article 943509.
For more information, click the following article number to view the article in the Microsoft Knowledge Base:
943509 (http://kbalertz.com/Feedback.aspx?kbNumber=943509/)
Description of the Jet 4.0 Database Engine hotfix package for Windows XP Service Pack 2, Windows Server 2003 Service Pack 1, Windows Server 2003 Service Pack 2, Windows Vista, Windows Vista Service Pack 1, and Windows Server 2008: October 23, 2007
The following files are available for download from the Microsoft
Download Center:
Download the Update for Windows Server 2008 (KB943509) package now. (http://www.microsoft.com/downloads/details.aspx?FamilyId=0E93E3AA-9B39-4C55-AD01-135B65682F85)Download the Update for Windows Server 2008 for Itanium-based Systems (KB943509) package now. (http://www.microsoft.com/downloads/details.aspx?FamilyId=05362CA1-841C-462C-8932-C296DFFED06E)Download the Update for Windows Server 2008 x64 Edition (KB943509) package now. (http://www.microsoft.com/downloads/details.aspx?FamilyId=49CAE400-3ED9-4833-84ED-4C995221EA31)Download the Update for Windows Vista (KB943509) package now. (http://www.microsoft.com/downloads/details.aspx?FamilyId=00152047-882C-49C6-A48B-16307D1A2EA9)Download the the Update for Windows Vista for x64-based Systems (KB943509) package now. (http://www.microsoft.com/downloads/details.aspx?FamilyId=EC88DFA4-0FAC-4CB1-855B-3C84608C8B6B)Back to the top
WORKAROUND
If you cannot apply the hotfix that is described in Microsoft Knowledge Base article 943509, use one of the following methods to work around this problem:
| • | Update the application. To do this, copy the retrieved data from the original Visual C++ variable to a new variable. Then, insert or update the data from the new variable. |
| • | Update the database design. To do this, use one of the following methods:| • | Modify the column widths to one character larger than any expected data. | | • | Redefine the width as a non-fixed length. |
|
Back to the top
STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Back to the top
APPLIES TO
| • | Microsoft Visual Studio 2008 Standard Edition |
| • | Microsoft Visual Studio 2008 Professional Edition |
| • | Microsoft Visual Studio 2008 Academic Edition |
| • | Microsoft Visual Studio 2005 Standard Edition |
| • | Microsoft Visual Studio 2005 Professional Edition |
| • | Microsoft Visual C++ 2005 Express Edition |
| • | Microsoft Visual Studio .NET 2003 Enterprise Architect |
| • | Microsoft Visual Studio .NET 2003 Enterprise Developer |
| • | Microsoft Visual Studio .NET 2003 Academic Edition |
| • | Microsoft Visual Studio .NET 2003 Professional Edition |
| • | Microsoft Visual C++ .NET 2003 Standard Edition |
| • | Microsoft Visual Studio .NET 2002 Enterprise Architect |
| • | Microsoft Visual Studio .NET 2002 Enterprise Developer |
| • | Microsoft Visual Studio .NET 2002 Professional Edition |
| • | Microsoft Visual C++ .NET 2002 Standard Edition |
| • | Windows Server 2008 Enterprise |
| • | Windows Server 2008 Datacenter |
| • | Windows Server 2008 Standard |
| • | Windows Server 2008 for Itanium-Based Systems |
| • | Windows Server 2008 Standard without Hyper-V |
| • | Windows Server 2008 Enterprise without Hyper-V |
| • | Windows Vista Enterprise |
| • | Windows Vista Home Basic |
| • | Windows Vista Ultimate |
| • | Windows Vista Business |
| • | Windows Vista Service Pack 1 |
| • | Windows Vista Enterprise 64-bit Edition |
| • | Windows Vista Home Basic 64-bit Edition |
| • | Windows Vista Home Premium 64-bit Edition |
| • | Windows Vista Ultimate 64-bit Edition |
| • | Windows Vista Business 64-bit Edition |
Back to the top
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate
Be the first to leave feedback, to help others about this knowledge base
article.
(Optional) Name
(Optional)
Public URL Or Email
Comments
No
HTML -- Text Only Please