How can I Test for success of "DoCmd.RunSQL strSQL" Insert Statement.
I am archiving records to an external Access DB - and it is working.
Is there a 'Best Practice' for verifying that the Insert to the external DB was successful before I Delete the Archived row[s] from the Production DB?
I'd appreciate if you could point me in the right direction. I have not been able to find the answer on GoogleIsMyFriend yet!!
Currently, I am turning the SetWarnings Off before the Insert and On after.
Thanks in advance.