Data Has Been Changed

S

Steve King

I'm trying to handle a 7878 error (data has been changed)
in a relatively sophisticated app. First the application
allows the user to create links to the main form and
updates the subform. Next the user can remove that link
and the subform no longer contains the data. I am able to
complete this sequence once with absolutely no errors.
When I try to remove the link on the second sequence I get
the 7878 error. According to the knowledgebase article
302492 this is caused by the ODBC Refresh Interval being
set to 1500 seconds and it recommends performing a manual
refresh. When I refresh the form in VBA code it returns
to record one. When I use a bookmark to return to the
correct record I get another error. Any assistance would
be appreciated.

Thanks,
Steve King
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error - Data Has Been Changed #7878 1
"The operation cannot be performed because the object has been deleted." 0
Runtime Error 7878 Data has been Changed 0
The data has been changed message 4
Remote stopped working in PowerPoint Presenter View 0
Refresh data in sub forms when one sub form is edited 8
Run-time error '7878' - The data has been changed. 0
You must use the dbSeeChanges option with Open Recordset whenaccessing a SQL Server table that has a 1

Top