Uniqueidentifier question

[Rupey]

I am using Access 2003 .adp as a front end to a SQL Server 2000 database.
I am creating a table (Master) and want to use uniqueidentifier as the
Primary Key.

If I create a Detail table as a one-to-many relationship with Master what
data type do I use as the foreign key field pointing to Master?

And what is the type I would use in VBA code?

 

[Alex White MCDBA MCSE]

Hi,

using the uniqueidentifier type as the primary key makes life more
complicated, I personally use the numeric data type with an identity field,
the only time I have ever used the uniqueidentifer type for
primary/secondary keys was in a replicated sql environment across a WAN,
what you are trying to do is possible but hard work.

Hope it helps.