Hyperlink column type in SQL

[Paul]

I'm trying to create a table using SQL in Access, but can't seem to
create a column with type Hyperlink.

I'm actually trying to do this via Delphi and using the TADOCommand
component to run SQL on the database. It's all working well, apart
from the Hyperlink column.

Thanks,

Paul Thompson.

 

[Allen Browne]

A hyperlink field is essentially a memo field with a special attribute set
so Access treats it as a hyperlink. AFAIK, there is no way to do that with a
DDL query statement, i.e. you must use DAO or ADOX.

 

[Paul]

Thanks, can you give me any pointers how I might do this using ADOX
then? I've imported the 'Microsoft ADO Ext 2.7 for DDL and Security"
Library.

Paul.

 

[Allen Browne]

Set:
Properties("Jet OLEDB:Hyperlink")
of the Column in the Table of the Catalog.

I found some of those properties did not set correctly with ADOX 2.7, so if
you run into problems, you might try 2.8.

For some of these properties, you may also find that they can only be set
when originally creating the Column.