APPENDING DATA TO ANOTHER TABLE

[JWJ]

I am puzzled. I created table(table 1), copied it to another table (table 2), and then added several fields to table 2. I then used a query to delete the records in table 2, and attempted to append table 1 to table 2 (an append query). I keep getting a "Microsoft Access was unable to append all the data to the table" error message.

I could append data from table 1 to table 2 before I added the extra fields.

Any suggestion, comments, or work arounds? I am really stumped - this is critical to the processing data in a major application.

Thank you for whatever assistance you can provide.


JWJ [sig][/sig]

 

[Robertd]

Hi JWJ,

you should carefully read the error message it will usually tell you the reason like it couldn't append the records becuase

a cause duplicate key
b incorrect data types
c one or more of the fields have validation rules set
d no records exist in a related table

likely check that the later is not the cause as you might have set the required and or some other validation rule for the additional fields.

HTH
Robert
[sig][/sig]