Does Access have a function comparable to MS SQL's NEWID()?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Janet - 31 Mar 2007 21:10 GMT

1. Do any versions of Access have a NEWID() function like MS SQL?
2. Are there any comparable functions _besides_ rnd()?

Janet

Reply to this Message

storrboy - 31 Mar 2007 21:20 GMT

> 1. Do any versions of Access have a NEWID() function like MS SQL?
> 2. Are there any comparable functions _besides_ rnd()?
>
> Janet

I'm not sure what NEWID does.
Maybe there is an alternative depending on what it is you are trying
to do.

Reply to this Message

Sylvain Lafontaine - 01 Apr 2007 00:56 GMT

For tables? Yes: create a autonumber field and change the Field Size from
Long Integer to Replica Id.

For VBA code, you must create your own:

http://www.trigeminal.com/code/guids.bas
http://www.trigeminal.com/lang/1033/codes.asp?ItemID=9#9
http://www.trigeminal.com/usenet/usenet011.asp?1033

Signature

Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)

> 1. Do any versions of Access have a NEWID() function like MS SQL?
> 2. Are there any comparable functions _besides_ rnd()?
>
> Janet

Reply to this Message