Recordset Prop. = Dynaset (Inconsistent Updates) - What's the catch??

[jdttek]

I have a form based on a multitable (several One-to-Many relationships) query that gives the usual "Cannot update Rcordset". I understand why and realize there is nothing I can do to fix the query HOWEVER, I see that RecordsetType Property allows for "Dynaset (Inconsistent Properties)" which allows updating the form and tables even with the locked query. Seems almost too good to be true, so figure there must be a hidden mine somewhere.
I am not concerned about referential integrety. In fact, I am intentionally creating orphan records on the many side that will then be archived using unmatched records query to identify them.

Anyone with experiance (good or bad) on Dynaset (Inconsistent Updates) to allow edits to form based on loced query??

Thanks

JDTTEK

 

[jbehrne]

Hi,

I have used it in the past when I recieved the same error that you did. I have not run across any problems as far as the updates go.

HTH,

jbehrne