access 2003 update

[bbglme1]

I have two tables that are identical in format. They contain different primary keys. I want to combine them into one table. I have tried to set up a table with all the primary keys of both tables and do an update. I keep getting invalid argument. The sql statement is valid. The problem appears to be the field with OEL object. In access 97 I have know problem. Does any one know how to solve this problem? The table in 2003 is too big to convert to access 97.

 

[neileg]

Just append the records to an empty table. Don't worry about preallocating the primary key.