Microsoft KB Archive/295201

= ACC2002: Error Message When You Try to Copy and Paste a Table That Has a Timestamp Field =

Article ID: 295201

Article Last Modified on 9/25/2003

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-



This article was previously published under Q295201



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

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



SYMPTOMS
When you try to copy and paste a table that has a timestamp field, you may receive the following error message:

Cannot update ''; field not updateable.

When you click OK, the table is created without data, and the table is not updateable.



CAUSE
You do not have Microsoft SQL Server 2000 Desktop Engine or Microsoft SQL Server installed locally.

NOTE: The previous version of Microsoft SQL Server 2000 Desktop Engine is named Microsoft Data Engine (MSDE).



RESOLUTION
Install Microsoft SQL Server 2000 Desktop Engine (or SQL Server) locally.

For additional information about how to install the Microsoft SQL Server 2000 Desktop Engine, click the article number below to view the article in the Microsoft Knowledge Base:

290627 ACC2000: Microsoft SQL 2000 Desktop Engine Is Not Installed by Office XP Setup

NOTE: Installing Microsoft SQL Server 2000 Desktop Engine (or SQL Server) locally corrects the problem permanently. You no longer receive the error message and your tables will be populated and will be updateable.

If you do not want to install Microsoft SQL Server 2000 Desktop Engine or SQL Server, you can work around this error by adding a primary key to the copy of your table. You will still receive the error message after this workaround, and you will have to fill the data in the table by appending or copying the data from the original table. However, after this workaround, your data will be updateable.



Steps to Reproduce the Behavior
 On a computer that does not have Microsoft SQL Server 2000 Desktop Engine or SQL Server installed, create a new Access project (Existing Data) and link to data on another computer.  Create the following table, and then save the table as Table1:   Table: Table1 Field Name: ID [Primary Key] Data Type: uniqueidentifier Allow Nulls: No

Field Name: Test Data Type: timestamp

Fieldname: MyInfo Data type: varchar  Save the table, open it in Datasheet view, add some data to the MyInfo field, and then close the table. Click Table1, and then click Copy on the Edit menu.</li> Click Paste on the Edit menu.</li> In the Past Table As dialog box, type CopyTable1 in the Table Name box, and then click OK. Note that you receive the following error message:

Cannot update 'Test'; field not updateable.

When you open the table, you see no data and no available new record.</li></ol>

Additional query words: pra

Keywords: kberrmsg kbprb KB295201

-

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

© Microsoft Corporation. All rights reserved.