Is there any way to "catch" a SQL error when updating BO SQL through VBA using DataProvider.SQL? (I need a DAO workspace to rollback if there is an error.) Also, if I use this DataProvider.SQL to change the SQL and the user is required to enter a prompt and they select 'Cancel' the query continues without a value for the prompt? Are there any ways around this? Thanks in advance.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
DataProvider.SQL
- Thread starter TJLMO
- Start date