MS Access Hyperlink Data Type

[a23freak]

I am importing Oracle db tables into an Access db. I need to create a query that will create a new field and make the data type a Hyperlink. It seems that Access does not like the Alter Table cmd for this. It works fine with Text, Number, etc so I know that the general syntax is correct. Is there something special I have to add into the SQL statement to get Access to create this new field with the Hyperlink data type?

 

[Remou]

Note: You cannot create "AutoNumber Replication," "HyperLink," or "Lookup" type fields using a Microsoft Access DDL SQL statement. These field types are not native Jet field types and can be created and used only by the Microsoft Access user interface. The MyBinary field above is a special fixed-length binary field, which cannot be created via the Microsoft Access user interface but can be created using a SQL DDL statement.

From: How to use common Data Definition Language (DDL) SQL statements for the Jet database engine

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

Have you considered FollowHyperlink?

 

[Remou]

Unless DAO would suit:

    Set db = CurrentDb

    Set tdf = db.TableDefs("tblTable")

    With tdf
        Set fld = .CreateField("Field1", dbMemo)
        fld.Attributes = 32770
        .Fields.Append fld
    End With