[dba-SQLServer] Parent Child and GUIDs

On 14 Oct 2004 at 8:34, Andy Lacey wrote:

> Hi
> If a SQL Server parent table has a GUID as its unique key, and I want to
> link an Access child to it, can I? and if so what data type do I give the
> linking key field in the child table? I want this to work for a form/subform
> affair using LinkMaster and LinkChild.
> 

Access calls GUIDs "ReplicationID"s. They are stored as a 128 bit (16 byte) 
number.

Set the "Data type" of the Access field to "Number".  Set the "Field size" 
of the number to 'ReplicationID".



-- 
Stuart