My table has 300 fields or columns. I have two tables (same fields) and I need to do a single update query that update all the fields on a primary key. I think this can be automatically using Query Designer. Right?
I have not used 2007, but I assume you can update providing the primary key is the same name and data type etc. But updating 300 fields may cause problems performance wise. Make sure you have a copy of both tables before you update in case there are problems.