Accessing SQL Server GUID (uniqueidentifier) data

[Rob M]

I have an Access 2003 front end to a SQL Server database. A control on one
of my forms gets data from a column with data type 'uniqueidentifier.' But I
am unable to then store that data in another column (in another table) also
of data type 'uniqueidentifier.' Curiously, I AM able to apply
StringFromGUID( ) to the data and store the output STRING - even though I am
storing it in a column of data type 'uniqueidentifier.' But I want to store
the data as uniqueidentifier. Can anyone tell me how to do that?

 

[david epsom dot com dot au]

A unique identifer is a string. So if you are storing the
value in the column, it sounds like you are ok. Does it
come back ok when you read it back?


Access is always playing with the values when you don't
want it to: adding 'guid' to the start of the string,
adding or taking off the {}. That is why it is a good
idea not to use unique identifier columns with Access
(apart from the replication columns that you never use
for data).

(david)