Developer Forum

All,

Trying to run an append query from one db to the other, basically so I can
get all the data from my replica set back into one db. So using a new db
with links from replica to master.

If I copy and paste the records manually then its fine, if I run an append
query I get this message

Error Number 3666

You cannot modify the replication system object <fieldname>

Anyone got any ideas.

Cheers

Tony Doyle
Wilmslow
England

You must use an append query that lists the specific fields to append, and
which would not include the [hidden] replication system fields. Those fields
cannot be written to.


--
MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies
Windows International Division

This posting is provided "AS IS" with
no warranties, and confers no rights.

I should mention, that the field name is an autonumber field set as
replication id.

Even if i do it through code or sql, it bombs out, but if I do it using cut
and paste it is ok... quite bizarre really

Td

Thanks Michka

Unfortunately this doesn't work. The field is key, and is of type number /
replication id.
Cut and paste works fine, but even if I write code to add the values to it
from the "old" table it still doesn't work.

Very strange

Td

"Michael (michka) Kaplan [MS]" < XXXX@XXXXX.COM > wrote in

fields


can
append

As I mention up at

http://www.yqcomputer.com/

it is a bad idea to use replication IDs in tables. I could keep on adding
reasons such as the one you mention (which does not happen in all versions,
if I recall) but you really only need one reason to not set your hand on
fire. Anyone who ignores four is gonna burn themselves even if I list 100.


--
MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies
Windows International Division

This posting is provided "AS IS" with
no warranties, and confers no rights.





and


db

Thanks Michka,

Have read your article, and yes it makes sense, I am using Access 2000. I
have already gone down the replication id field way, but it is too late to
reverse it out.

Any ideas how I can get the data in, or should I just cut and paste?

Cheers

Td
"Michael (michka) Kaplan [MS]" < XXXX@XXXXX.COM > wrote in

versions,


/
it



I
new

honestly do not know of a way -- but then again, I never spend a ton of
time thinking about the road not travelled....


--
MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies
Windows International Division

This posting is provided "AS IS" with
no warranties, and confers no rights.

"Td" < XXXX@XXXXX.COM > wrote in message
news: XXXX@XXXXX.COM ...
adding
100.
number
to
append,
Those
so
an

heers anyway Michka...

Looks like I will have to write some clipboard manipulation code instead...

Td

"Michael (michka) Kaplan [MS]" < XXXX@XXXXX.COM > wrote in
message news:% XXXX@XXXXX.COM ...
I
to
on
in
basically
a