I have tried Editing Database Information with a Dialog and found it works great. Two comments/questions related to shared databases:
If I open the dialog set up to edit data as described in the rundialog help page, and the user presses the Cancel button, the active record is locked and remains locked after the dialog closes. I thought it would be better not to lock the record when Cancel is pressed.
Second, when the Ok button is pressed, the record is locked. Wouldn’t it be better to lock the record, upload the changes, the commit the changes (i.e. unlock the record)?