Stephen
stephen at bondsoftware.co.nz
Tue Jul 29 16:17:13 CDT 2008
>From long ago in the mind's recesses, 7878 was the error code for 'another user has saved changes to this record while you were looking at it', and then (iirc) only when the locking scheme is Optimistic. In A97 I believe the dialog box suggested you the click OK to refresh. But it was all long ago ... and I seem to remember this message sometimes when I was the only person anywhere near the database. Stephen Bond -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at Beach Access Software Sent: Wednesday, 30 July 2008 8:01 a.m. To: Stephen Subject: [AccessD] Data Has Been Changed Dear List: I'm updating a field on different form that the one I'm on using: Forms!Matters!MatterActionsSubform!DueDate = Me.ActionDate and I get an error 7878 Data has been changed. If I debug and hit F5 it carries on OK and updates the field in the target form. But I can't find much about this 7878 or how to work around the problem. Does anyone have any experience with this error? MTIA Rocky Smolin Beach Access Software 858-259-4334 www.e-z-mrp.com <http://www.e-z-mrp.com/> www.bchacc.com <http://www.bchacc.com/> -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com