How to create GUID Autonumber programmatically in ms access

Question

How do I create guid autonumber field programmatically using C#?

Answer 1

In order to make your GUID field auto-increment, use GenGUID() as it's default value.

This works in Access using ADO. Perhaps a similar statement will work in C#:

CurrentProject.Connection.Execute "CREATE TABLE hede (Id Guid DEFAULT GenGUID())"

Answer 2

This might be helpful:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q180841

Also, using DAO:

What is the MS Access SQL syntax to create a field of type Hyperlink?