Replication with PK GUIDs

[waka]

Hi,

We have a database that will require replication and synchronization with tablet PCs and other desktop computers. As our company standard, we use GUIDs for the primary keys in almost all of our tables. Our database is and will remain in the Access .mdb format. I'm thinking about using the Access Replicator tool for our needs, however I know there may be a problem with our pk GUIDs. When using GUIDs as primary keys, Microsoft Jet Engine does not insert the s_GUID field into the table, which precludes the use of the Conflict Viewer. What I am unclear of is if a conflict table is still created, and if I can still find out what record/table is causing a conflict.

Thanks,

Sarah

 

[dfenton]

The problem is with the built-in conflict viewer, not with the data. You'd have to build your own conflict resolver.

Access does not handle GUIDs well at all:

http://trigeminal.com/usenet/usenet011.asp?1033

There is really no valid reason to use them, in my opinion.