Создание ключа (ADOX)По материалам: https://www.everythingaccess.com/tutorials.asp?ID=ADOX-programming-examples#ShowAllTables Function CreateKeyAdox() 'Purpose: Show how to create relationships using ADOX. Dim cat As New ADOX.Catalog Dim tbl As ADOX.Table Dim ky As New ADOX.Key Set cat.ActiveConnection = CurrentProject.Connection Set tbl = cat.Tables("tblAdoxBooking") 'Create as foreign key to tblAdoxContractor.ContractorID With ky .Type = adKeyForeign .Name = "tblAdoxContractortblAdoxBooking" .RelatedTable = "tblAdoxContractor" .Columns.Append "ContractorID" 'Just one field. .Columns("ContractorID").RelatedColumn = "ContractorID" .DeleteRule = adRISetNull 'Cascade to Null on delete. End With tbl.Keys.Append ky Set ky = Nothing Set tbl = Nothing Set cat = Nothing Debug.Print "Key created." End Function |
|||
L.E. 27.06.2022 |