As many of you probally know, Access 2000 /Jet 4.0 replication uses column-level tracking by default to prevent conflicts in multi user environements. IE: two users can be editing the same record without a conflict as long as they are not editing the same field within that record. (this is compared to row-level tracking used in earlier versions).

My question is this, why does Access 2000 enable row-level tracking with linked tables by default when other default behavior uses column-level? Im wondering if there is a logic behind this? This can be seen by linking a table from one dbase to another and viewing the linked tables properties.

Just curious here. I always post/read/answer questions pertaining to how to's, thought it might be interesting to discuss dbase theory.