I'm working with a Visual Basic app that needs to update data in an Access database. Everything works fine, but how do you do a routine like the following:
If a record exists then
update a field in the existing record
insert record with appropriate data
By the way, I'm not using the Data control - I just want to use statements through the Jet engine.