Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.
Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.
Public Sub Drop_SQL_Relationships(ByVal sTable As String, ByVal sRelationship_Name As String) On Error GoTo EH Set con = New ADODB.Connection con.Open "Provider=SQLOLEDB;Data Source=220.127.116.11,1444;Network Library=DBMSSOCN;Initial Catalog=psql;User ID=Gxxxx;Password=mcc4;" Set cmd = New ADODB.Command Dim sSQL As String sSQL = "ALTER TABLE [" & sTable & "] DROP CONSTRAINT " & sRelationship_Name With cmd .CommandText = sSQL .CommandType = adCmdText .ActiveConnection = con .Execute End With Set cmd = Nothing Set con = Nothing Exit Sub EH: MsgBox Err.Description End Sub
|MS Access vba Alter Table Drop Column (3rd column in table)||5||33|
|MS Access 2012, Split Form||2||38|
|Access/Visual Basic Question||3||23|
|Database keeps telling me Recordset Locked||10||21|