I would like to create an ADO recordset that basically takes two tables and adds a row to each but I am unable to do this I get a "object or provider is not capable of performing..." error.
Can anyone tell me how to do this?
I want to do this because I have a form that is bound to 2 tables and I want to have a custom ADDNew option.
Basically something like this:
Dim rs As New ADODB.Recordset
rs.Open "SELECT * FROM Table1, Table2", cn, adOpenKeyset, adLockOptimistic
ANY IDEAS WOULD BE GREATLY APPRECIATED.