Edit

Share via

Key object (ADOX)

  • Article

Applies to: Access 2013, Office 2013

Represents a primary, foreign, or unique key field from a database table.

Remarks

The following code creates a new Key:

Dim obj As New Key

With the properties and collections of a Key object, you can:

  • Identify the key with the Name property.

  • Determine whether the key is primary, foreign, or unique with the Type property.

  • Access the database columns of the key with the Columns collection.

  • Specify the name of the related table with the RelatedTable property.

  • Determine the action performed on deletion or update of a primary key with the DeleteRule and UpdateRule properties.