replication id function?

[Keith G Hicks]

I need to generate a replicationID value in code (not in a table). In MS
T-SQL I can use the NEWID() function to get something like
"0323E5D3-D54D-4842-86B0-47CE25D0EFDB"

How can I do this in MS Access 2k?

Thanks,

Keith

 

[Brendan Reynolds]

There's a VB example at the following URL that looks as though it should
work in VBA ...

http://www.vbcity.com/forums/topic.asp?tid=1713

Alternatively, you could use a table. Just add a record to the table, grab
the value from the newly-created record, then delete the record again.

 

[Keith G Hicks]

Thanks Brendan. The first example in that site works great in vba without
any mods. Much appreciated. I thought about using the table idea but figured
there must be a code way to handle it.

Keith


There's a VB example at the following URL that looks as though it should
work in VBA ...

http://www.vbcity.com/forums/topic.asp?tid=1713

Alternatively, you could use a table. Just add a record to the table, grab
the value from the newly-created record, then delete the record again.