Access FE, SQL Server BE. I run a simple insert query in Access in the GUI. A no dup index on two fields in the table rejects it with an error message as it should. However
also fails but without an error being displayed so I can't trap it. Same goes for CurrentDb.Execute sSQL, dbSeeChanges I have preceded that statement with docmd.setwarnings(true). Is this expected behaviour?
Code:
Set qry = CurrentDb.QueryDefs("query2")
qry.Execute dbSeeChanges
also fails but without an error being displayed so I can't trap it. Same goes for CurrentDb.Execute sSQL, dbSeeChanges I have preceded that statement with docmd.setwarnings(true). Is this expected behaviour?