How to define an autonumber field with a field size of Replication ID?

[Laser Lu]

Can anybody tell how to define an autonumber field or column of a table in
Access using Jet SQL? It is necessary to use SQL and the field size should
be set to Replication ID (GUID in Access, 16 bytes).

 

[Douglas J. Steele]

When you've got the table open in Design mode, select the Autonumber field.
In the information at the bottom, set the Field Size to Replication ID.

However, you may want to read what Michka's got at
http://www.trigeminal.com/usenet/usenet011.asp about why GUIDs aren't a good
choice for Primary Keys in Access.

 

[Laser Lu]

Thank you, Doug, for pointing out how to do this setting in Access Design
view.
However, actually, I've known this operation, and my problem is how to
define it just using SQL.
Thanks again for your reply! And, I'll check out Michka's article.

 

[Douglas J. Steele]

I doubt very much that it's possible to do using SQL. Since SQL is a generic
interface, it doesn't necessarily support DBMS-specific things.