How to generate GUID in Access ADP

  • Thread starter Thread starter Fred
  • Start date Start date
F

Fred

I have a table in a sql server 2000 database that has a
field set to "uniqueidentifier", how does this GUID get
generated when using an Access ADP front end?

I have looked and can't come up with a way of this being
generated from Acess, any help is greatly appreciated.
Thanks
Fred
 
Hello, Fred!
You wrote in message on Thu, 16 Sep 2004 13:02:37 -0700:

F> I have a table in a sql server 2000 database that has a
F> field set to "uniqueidentifier", how does this GUID get
F> generated when using an Access ADP front end?
F> I have looked and can't come up with a way of this being
F> generated from Acess, any help is greatly appreciated.

Use the MSSQL functionality.

? CurrentProject.Connection.Execute("select newid()").Fields(0)

With best regards, Igor.
ICQ: 111469481
 
Back
Top