access 2003 update

bbglme1

New member
Local time
Today, 14:22
Joined
Dec 19, 2007
Messages
1
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.
 
Just append the records to an empty table. Don't worry about preallocating the primary key.
 

Users who are viewing this thread

Back
Top Bottom