How to define an auto increased GUID field in Access?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Laser Lu - 12 Dec 2003 16:38 GMT

I wanna define an autoincrement column in a table just using Jet SQL, and
the field size must set to Replication ID (GUID in Access, 16bytes in
storage size). Can anybody help me? Thanks a lot!

--
Best regards,
Laser Lu

Reply to this Message

Michael \(michka\) Kaplan [MS] - 12 Dec 2003 20:41 GMT

See

http://trigeminal.com/usenet/usenet011.asp

for explanation of why that is usually a really bad idea.

Signature

MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies

This posting is provided "AS IS" with
no warranties, and confers no rights.

> I wanna define an autoincrement column in a table just using Jet SQL, and
> the field size must set to Replication ID (GUID in Access, 16bytes in
[quoted text clipped - 3 lines]
> Best regards,
> Laser Lu

Reply to this Message