How to create a Hyperlink-column in an Access database table with VB6?

[DamianC]

Hi,

I'm searching for some time now for code to create a hyperlink column in a table in an Access database, with Visual Basic 6 ( a column containing hyperlinks)
Creating other type of columns is no problem, e.g. Text columns, Date columns:

VB6 code:

Set MyDatabase = New ADODB.Connection
MyDatabase.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & TableName & ";" & "Persist Security Info=False"
MyDatabase.Open

MyDatabase.Execute "CREATE TABLE " & NewTableName & "(" & _
      "ID HYPERLINK  ," & _                    (HYPERLINK gives a runtime error)
      "ExpCode VARCHAR(50)  ," & _        (creates a text column - works fine)
      "Concerning   MEMO ," & _             (creates a memo column - works fine)
      "Date_ DATETIME  )"                     (creates a date column - works fine)

VARCHAR(50), MEMO, DATETIME all create the type of column that I want, only HYPERLINK, or LINK, or HYPERLINKNAME... etc... (tried them all) do not create a hyperlink column but give errors.
I searched for hours but I just can't find it.

Is there any way to create a Hyperlink column with VB6-code?

Help will be greatly appreciated!