I would like to know the best way to determine if a SQL statement was successful. Mostly ... for inserts and updates. I would like to be able to check the number of records affected by the SQL statement. I am
not using a backend of any sort .. just normal Access database.
I like to use DoCmd.RunSQL statements .. but understand that I cannot do this. I go back to the Access 2 days .. and guess I just never learned the best way to do this.
Normally I let the insert run ... and then do a Dlookup (or actually Elookup) and check if that record is there. Works .. but is there a better way ?
Thanks