[dba-SQLServer] Parent Child and GUIDs

Got it. Terrific. Thanks Stuart.

-- Andy Lacey
http://www.minstersystems.co.uk 

> -----Original Message-----
> From: dba-sqlserver-bounces at databaseadvisors.com 
> [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf 
> Of Stuart McLachlan
> Sent: 14 October 2004 22:57
> To: dba-sqlserver at databaseadvisors.com
> Subject: Re: [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
> 
> 
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 
> 
>