Paste error, access 2000

[Hugh N. Ross]

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

 

[tina]

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]

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]

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