Last post Dec 09, 2008 02:58 AM by Mikesdotnetting
Dec 08, 2008 06:43 PM|robdob|LINK
The following DDL doesn't work when trying to globally update a GUID field within a access table. Any help would be appreciated..
UPDATE MyTable SET [Myguid] = GenGUID()
Dec 08, 2008 07:28 PM|hans_v|LINK
Please don't place the same question twice. I think a temp table will do, as explained in the other topic. I'm not sure why u can'r use the GenGuid() Function in SQL (error is 'Undefined function 'GenGUID' in expression', but it works as the default value
of a GUID... strange!
Dec 08, 2008 08:32 PM|robdob|LINK
I'm not sure why you think this is the same question, this question is about globally updating the access table where the other question is about creating a GUID Autonumbering field wihtin an access table via ddl..
Dec 09, 2008 02:58 AM|Mikesdotnetting|LINK
I'm not sure why you think this is the same question
I know why Hans thinks that. It's because while your initial post asked about creating an Autonumbering GUID within Access via DDL, it then went on to ask how to apply the GUID to records that already exist. And you are still receiving help there on that
issue. If the other thread has provided satisfactory answers for you, please mark it as resolved. Because as it stands at the moment, you have two open threads currently discussing the same topic.