Hi all,

Using 2007 now as a frontend with Oracle RDMS. Existing 2003 Access .mdb
is opened with the new version, 2007. However, adding of records, via a form
or query, fails. (Note, it works fine with Access 2003.) The query behind
the form and the other query consists of two tables with a one-to-one
relationship. (The left-side table contains a foreign key which the right-
hand table is the parent table.) The error message is that the Access engine
cannot find the record, in the right-side table, with key matching fields.

I have figured out a few different fixes. The first one is to change the
query's relationship to one-to-many. The results are still the same since
the many side (the right side table) is the parent table, and thus the same
set of records are returned by the query. The other solution is to set the
form's Recordset Type property from Dynaset to Dynaset (Inconsistent Updates).
I'm using the first solution since I couldn't find anything on the web about
the second solution, plus the name of the property's value explains enough.

I have a fix but still have yet to confirm if this is the true fix. Can't
find anything on the web. Any ideas and/or suggestions welcomed. Note: I
also converted the database to 2007 but the issue still persists.

Regards