[dba-SQLServer] Parent Child and GUIDs

You can set an autonumber to produce GUIDs by making it a replicationID
type.  But GUIDs are a weird combination that amounts to an array, so
the only success I've had with them in converting them back and forth to
strings for comparison using StringFromGUID and GUIDFromString.  DAO
supports a dbGUID datatype enum

Charlotte Foust


-----Original Message-----
From: Andy Lacey [mailto:andy at minstersystems.co.uk] 
Sent: Thursday, October 14, 2004 10:07 AM
To: dba-sqlserver at databaseadvisors.com
Subject: RE: [dba-SQLServer] Parent Child and GUIDs


Looked in AXP and don't see it.

-- 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 Francisco Tapia
> Sent: 14 October 2004 16:31
> To: dba-sqlserver at databaseadvisors.com
> Subject: Re: [dba-SQLServer] Parent Child and GUIDs
> 
> 
> iirc, Access 2000 and later have a guid data type.
> 
> 
> On Thu, 14 Oct 2004 08:34:39 +0100, Andy Lacey
> <andy at minstersystems.co.uk> 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.
> > 
> > -- Andy Lacey
> > http://www.minstersystems.co.uk
> > 
> > _______________________________________________
> > dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> > http://www.databaseadvisors.com
> > 
> > 
> 
> 
> --
> -Francisco
> <a href="http://pcthis.blogspot.com">Pc This! pc news with 
> out the jargon</a> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 
> 
> 

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com