[dba-SQLServer] Parent Child and GUIDs

I have done this via converting the GUID to a string and linking.  There may be more elegant solutions but this was quick and effective for the small app I was working at the time.

-Chris Mackin

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of
Francisco Tapia
Sent: Thursday, October 14, 2004 9:31 AM
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