How to verify Insert Operation

[Sibtain]

I am using an insert query how can i verify it programetically without looking into the table.

e.g db.execute("Insert into xyz values (a,b,c,d);")



is there any true or false or any other indicator or anything elase which verify the insert operation

Regards
Aryan

[ketbdnetbp]

One way would be to check the number of records in the table before the process and put that number into a variable. Check out the DCount() function in Access Help.

Then, run the insert operation.

Once completed, check the record count again and put that number into a different variable.

Compare the two variables, if equal operation was unsuccessful. If the second variable is greater than the first by one, operation was successful.

Hope this helps,

Jim