VB 6.0 - GUID MsAccess - Asked By iomega 55 on 01-Nov-05 01:02 AM

I need to retrieve information from some table(s).

SELECT * FROM mytable

But the important issue is I need a unique identifier for each row, I know that in SQLServer exists Newid() function who dynamically generates a value for each row.

Does it exist an alternative when I make a query on a MsAcces database?

Thanks in advance.

guid - Asked By Sunitha Nambari on 01-Nov-05 11:52 PM

hi,

chk this,

http://www.kayodeok.btinternet.co.uk/favorites/kbofficeaccesshowto.htm

Hope it helps...

Regards,
Suneetha