Thanks for the quick response, Craig. Actually the receiving table also has an autonum field (they are both basically identical tables), so I'm not sure that appending from a temp cursor would help - wouldn't I get the same message?
>You have to append to a temp table or cursor, populate the id column there with the values you want for the master table, then append from the temp to the master table.
>
>Or, write code to append a record at a time, update the id, then do the next record.
>
>>I'm copying table contents from one file to another and ran into an error while copying a table with an autonumber field. It says the field is read-only (which makes sense, I guess), and won't copy the records using an append from statement. Is there a quick/standard way to get around this? I know I could do a file copy, but was hoping to just pull records as needed from the other table.
>>
>>As always, thanks in advance.
Steve Howie, owner
DaSH Technology
Denver, CO