If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Paste error, access 2000
I have two tables that have the same structure (as shown by the
documenter). I am trying to manually copy and paste a record from one table to the other. I get a paste error 'The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data'. The target table has an autonumber key field, several text fields and a memo field. The source table has the same fields except the key field is not autonumber. The error message does not identify any field name. I do not know what is wrong. Help would be appreciated. Hugh |
#2
|
|||
|
|||
Paste error, access 2000
AFAIK, you cannot manually enter a value into an Autonumber field, whether
by typing or by pasting, in the table's Datasheet view. instead, try writing a query on the source table, to pull the specific record you need. then convert that query to an Append query; you should be able to append a value into the Autonumber field - as long as that value does not exist in a record in the destination table OR in a record that was deleted since the last time the database was compacted. hth "Hugh N. Ross" wrote in message ... I have two tables that have the same structure (as shown by the documenter). I am trying to manually copy and paste a record from one table to the other. I get a paste error 'The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data'. The target table has an autonumber key field, several text fields and a memo field. The source table has the same fields except the key field is not autonumber. The error message does not identify any field name. I do not know what is wrong. Help would be appreciated. Hugh |
#3
|
|||
|
|||
Paste error, access 2000
I am still having trouble. I did a compact and repair just in case.
I made a select query that worked properly. I converted it to an append query. I checked the autonumber id field in the target table and put an unused id into the source table id field. I tried several such id values but for all of them I get an error, append failed due to validation rule violation. I cannot find any validation rule that could be violated. Do I have to resort to a vb module to fill and store a new record to the target table? Hugh tina wrote: AFAIK, you cannot manually enter a value into an Autonumber field, whether by typing or by pasting, in the table's Datasheet view. instead, try writing a query on the source table, to pull the specific record you need. then convert that query to an Append query; you should be able to append a value into the Autonumber field - as long as that value does not exist in a record in the destination table OR in a record that was deleted since the last time the database was compacted. hth "Hugh N. Ross" wrote in message ... I have two tables that have the same structure (as shown by the documenter). I am trying to manually copy and paste a record from one table to the other. I get a paste error 'The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data'. The target table has an autonumber key field, several text fields and a memo field. The source table has the same fields except the key field is not autonumber. The error message does not identify any field name. I do not know what is wrong. Help would be appreciated. Hugh |
#4
|
|||
|
|||
Paste error, access 2000
if the problem were connected with trying to append a value into the
Autonumber field, i'd think that you'd get some sort of "unique index" error, not a validation error. since i can't see your data or your table, all i can suggest is that you take a really close look at all validation rules that exist in that table - both at the field level and the table level, and including any multi-field indexes that may be set. then take an equally close look at the data you're trying to import. also, on going back to your original post, i see that the tables include several text fields. double check the FieldSize property of those Text data type fields; the default for text fields is set at 50, unless or until you change it under Tools | Options from the menu bar. perhaps you're trying to append more text data, into one or more of those Text fields, than is allowed by the FieldSize setting for the field(s). if so, just increase the field size as needed - up to 255. hth "Hugh N. Ross" wrote in message ... I am still having trouble. I did a compact and repair just in case. I made a select query that worked properly. I converted it to an append query. I checked the autonumber id field in the target table and put an unused id into the source table id field. I tried several such id values but for all of them I get an error, append failed due to validation rule violation. I cannot find any validation rule that could be violated. Do I have to resort to a vb module to fill and store a new record to the target table? Hugh tina wrote: AFAIK, you cannot manually enter a value into an Autonumber field, whether by typing or by pasting, in the table's Datasheet view. instead, try writing a query on the source table, to pull the specific record you need. then convert that query to an Append query; you should be able to append a value into the Autonumber field - as long as that value does not exist in a record in the destination table OR in a record that was deleted since the last time the database was compacted. hth "Hugh N. Ross" wrote in message ... I have two tables that have the same structure (as shown by the documenter). I am trying to manually copy and paste a record from one table to the other. I get a paste error 'The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data'. The target table has an autonumber key field, several text fields and a memo field. The source table has the same fields except the key field is not autonumber. The error message does not identify any field name. I do not know what is wrong. Help would be appreciated. Hugh |
Thread Tools | |
Display Modes | |
|
|