Re: Use GUID instead of AutoInc

I am puzzled.. how is the field shown in the Access GUI when you open the
table created by SQL in design
mode?


"Koen" <koen@xxxxxxxx> wrote in message
news:4815ca31@xxxxxxxxxxxxxxxxxxxxxxxxx
Using the Access GUI..

"Arthur Hoornweg" <antispam.hoornweg@xxxxxxxxxxxxx> wrote in message
news:4814885a@xxxxxxxxxxxxxxxxxxxxxxxxx
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

  • Counting expression doesnt work when sorted by count - Access 200
    ... However the following SQL script doesn't work. ... In design view the first query is as ... Sort - Descending ...
    (microsoft.public.access.queries)
  • conversion to sql
    ... How difficult is it to convert a database of Access tables to SQL that can ... then be linked to an access GUI. ... Prev by Date: ...
    (microsoft.public.access.tablesdbdesign)
  • Re: SQL
    ... > If you design right, you can *shift* much behavior to being data and ... > SQL is close to being Turing Complete. ... It is a bad habit of yours. ... If you're seriously suggesting that CRUD applications are equal ...
    (comp.object)
  • Re: Object-oriented thinking in SQL context?
    ... away from arrays and other non-OO data structures associated ... SQL is constrained to 'trivial' arrays. ... Design: Logical Design", 4th edition. ... Something analogous happens with database design. ...
    (comp.databases.theory)
  • Re: Why does 1:3 relationsihp require another table?
    ... Pro SQL Server 2000 Database Design ... > there can be a relation with NULLs in its tuples (hence 1NF models with ... > can only conclude that you do not believe Louis and Lewis are correctly ...
    (microsoft.public.sqlserver.programming)