Re: Use GUID instead of AutoInc

Koen wrote:
Access (2003) does not seem to support this datatype..

Do you create the database using a SQL script (Jet 4 OleDB provider)
or using the Access GUI?

I can use the datatype "uniqueidentifier" just fine in my SQL script.


--
Arthur Hoornweg

(In order to reply per e-mail, please just remove the ".net"
from my e-mail address. Leave the rest of the address intact
including the "antispam" part. I had to take this measure to
counteract unsollicited mail.)
.

Relevant Pages

  • Re: uniqueidentifier datatype
    ... (including compound keys). ... This GUID ... foreign table columns as a uniqueidentifier datatype too. ...
    (microsoft.public.sqlserver.programming)
  • Re: Use GUID instead of AutoInc
    ... IIRC, the data type is "uniqueidentifier" ... Arthur Hoornweg ...
    (borland.public.delphi.database.ado)
  • Re: Use GUID instead of AutoInc
    ... IIRC, the data type is "uniqueidentifier" ... Arthur Hoornweg ...
    (borland.public.delphi.database.ado)
  • Re: Use GUID instead of AutoInc
    ... Do you create the database using a SQL script (Jet 4 OleDB provider) ... or using the Access GUI? ... I can use the datatype "uniqueidentifier" just fine in my SQL script. ...
    (borland.public.delphi.database.ado)
  • uniqueidentifier
    ... But I am not able to see any column which is having 'uniqueidentifier' as ... datatype. ... CustName Varchar ... Shailesh ...
    (microsoft.public.dotnet.framework.aspnet)