Replication Changing Table Design

[dunc723]

I have a database with 8 tables. When I create a replica, one of the tables (only one) in the replica gets modified such that Data Type for all the fields is Calculated, with the effect that the data cannot be changed by the user. The table design is not changed in the Master. What the heck? Of course the table design cannot be modified in the Replica, and there's no reason to modify it in the Master. A second replica on a different server had the same result.



Any experience with this? Known cause and solution?

Thanks in advance.

[Alhassani]

Not that I'll be able to help at all with this, but is there anything that makes that 1 table different from the other 7? Like the 7 would be text entries, while that 1 is numbers or something?

[dunc723]

Nothing I know of - all the tables are a mix of Text, Dates, and Numbers.

[software_mike]

Hi dunc723! Well, it's now December 2017, and all of a sudden my Access 2010 database that I've been using for years is exhibiting this exact problem when I create a replica. Did you ever solve this issue?? This is driving me crazy!!!

Thanks in advance,
Mike Johnson