I am using ADODB for connecting ms-access database from a vc++ application.I want to insert record in access database;but if the record already exists in the access table then update query should run instead of insert query.
the above task can easily be done with stored procedure, but since ms-access does not provide facility of stored procedure I have to find some solution in vc++ code.
One solution could be to run "select query" before "insert/update query" to check existence of the record being inserted/updated. But this will take lot of time for code to execute for every record.
does anybody have any other elegant solution?please help...
Thanks in advance