Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.
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=126.96.36.199,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
|Access Runtime 2010 Error||17||33|
|DSum for Access||6||47|
|Access importing CSV that has commas in currency and needs 2 cols formated for numbers to text||5||35|
|format date field on certain entries||8||32|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
26 Experts available now in Live!