Unanswered: Cannot append to a table in Replica Database..wrong no of values !
I have created a replica database from a master, but now no append queries will work with either database, i get an error "No. of query values does not match destination fields", I know there are 3 or 4 hidden replica fields added to a table, but these should be added by the system.....but there not. HELP!
I'm using access 2000.
Care to share the source of this query (The SQL itself) - this can be accessed by opening the query in design view and switching to SQL view.
With this could we please have more information about your table - all field names and data types.
The more information you provide the more chance you give people of helping you
Well it shouldn't have worked
As I told a colleague yesterday - SQL is stupid; you have to tell it exactly what you want it to do.
Your statement read: "Stick the values 1, 2 and 3 into table1"
And SQL is saying: "Stick them where? which fields?"
You need to say: "Stick the values 1, 2 and 3 into table1 into Field1, Field2 and Field3 respectively"