Do u have the names/information of the table and the columns which get affected, when u insert some data from UI.
I hope you have more than one value getting inserted into a table.
What u can do is create a function, which would check for data inserted. This would accept the name of the table, the column names as an array and then the data to be verified also as an array.
U need to first create a connection to DB, this can also be part of a function. Once the connection is set, u can call the above created function and pass values. Use a boolean flag as a return from the above function.
// The following query returns one record which i have inserted via Application UI into Database and I hold it in Recordset object now i have to ensure (infact compare) that this DB record contains all the same values I had inserted during recording session
strQuery = "SELECT * FROM MY_TABLE WHERE CREATOR_ID = 'MZ'"
Set objRecSet = CreateObject("ADODB.Recordset")
Set objRecSet = objConn.Execute(strQuery )