Breaking News

Tuesday, June 26, 2012

Ex12: VBA - Delete relationships using ADOX


Function DeleteKeyAdox()
'Purpose: Delete relationships using ADOX.
Dim cat As New ADOX.Catalog
Dim tbl As ADOX.Table

Set cat.ActiveConnection = CurrentProject.Connection
cat.Tables("tblAdoxBooking").Keys.Delete "tblAdoxContractortblAdoxBooking"

Set cat = Nothing
Debug.Print "Key deleted."
End Function

No comments:

Post a Comment

Designed By Published.. Blogger Templates