Re: Use GUID instead of AutoInc

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


"Arthur Hoornweg" <antispam.hoornweg@xxxxxxxxxxxxx> wrote in message
news:480f63e4$1@xxxxxxxxxxxxxxxxxxxxxxxxx
Koen wrote:
I currently use access.. should I declare the field as a Number/Longint?


IIRC, the data type is "uniqueidentifier"



--
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: Use GUID instead of AutoInc
    ... IIRC, the data type is "uniqueidentifier" ... Arthur Hoornweg ...
    (borland.public.delphi.database.ado)
  • Re: Data Types
    ... >> Steve, ... >> Tibor Karaszi, SQL Server MVP ... >>> character varchar data type? ... A uniqueidentifier uses 16 bytes. ...
    (microsoft.public.sqlserver.programming)
  • Re: Data Types
    ... > moved to SQL Server and I don't know the best newsgroups yet. ... > Does a Unique Identifier data type take up less storage space than a 32 ... A uniqueidentifier uses 16 bytes. ... but I'm looking at the data types and think that the TimeStamp ...
    (microsoft.public.sqlserver.programming)
  • Re: Retrieving a Guid from a DataTable
    ... the column has a Uniqueidentifier data type. ... the GUID is stored as a Uniqueidentifier in the database. ... ArrayList ReadingRange = new ArrayList; ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Data Types
    ... >> character varchar data type? ... A uniqueidentifier uses 16 bytes. ... > of UPDATEs. ... >> When specifying a TimeStamp field, can you tell it only to update the ...
    (microsoft.public.sqlserver.programming)