Access 2007 Error 7878 The Data Has Been Changed
be down. Please try the request again. Your cache administrator is webmaster. Generated Fri, 30 Sep 2016 00:56:56 GMT by s_hv1000 (squid/3.5.20)
Custom Search UtterAccess Forums>Microsoft® Access>Access Forms Error 7878 "The data has been changed" Forum HomeSearchHelpUA Messages|-- UtterAccess.com NewsAccess Knowledge Center|-- Access Code Archive|-- Access Knowledgebase / FAQ|-- Access TutorialsMicrosoft® Access|-- Local Access User Groups (AUGs)|-- Interface Design|-- Access Q and A|-- Access Tables + Relationships|-- Access Queries|-- Access Forms|-- Access Reports|-- Access http://answers.microsoft.com/en-us/msoffice/forum/msoffice_access-mso_winother/write-conflict-error-has-now-been-replaced-with/f8f25d89-dc7f-41ac-afb0-488de34c136c Macros|-- Access Modules|-- Access Date + Time|-- Access Errors + Error Handling|-- Access Built-in Functions|-- Access Searching + Data Mining|-- Access Records|-- Access Security|-- Access Automation|-- Access Database Container|-- Tool bars, Menu bars + Ribbon|-- Access Services (Web Databases)|-- Access Data Access http://www.utteraccess.com/forum/error-7878-the-data-ch-t1352868.html Pages (Deprecated)|-- Access Data Projects - ADP|-- Access Runtime, Packaging & DeploymentAnd More...|-- Microsoft SQL Server|-- SQL Server Reporting Services|-- Microsoft SharePoint|-- Microsoft Internet Explorer|-- Visual Basic 6 and Earlier|-- Visual Basic 2003 and Later|-- ASP and VBScript|-- Web Development|-- PHP, Perl, MySQL and Postgres|-- Other Database Engines|-- BI Tools and Applications|-- JAVA and C#|-- GraphicsMicrosoft® Office|-- Microsoft Excel|-- Microsoft Excel FAQs|-- Microsoft Word|-- Microsoft Outlook|-- Microsoft PowerPoint|-- Microsoft FrontPage/Exp. Web|-- Other Microsoft ProductsPC|-- Network Issues|-- Q & A - Hardware|-- Q & A - Software|-- Q & A - Other PC|-- Virus + Security DiscussionUtterAccess Odds and Ends|-- General Chat|-- Q & A - UtterAccess.com Forums|-- Q & A - Access Wiki Options kbrewsterView Member Profile Feb 7 2007, 08:13 AM Post#1UtterAccess VI
Question Need help? Post your question and get tips & solutions from a community of 418,417 IT Pros & Developers. It's quick & easy. Run time https://bytes.com/topic/access/answers/192176-run-time-error-data-has-been-changed error, "The data has been changed." P: n/a Bill Short Hello All, I have a popup form that is called from a command button on the main form. The main form's data source is tblA. The data source for the popup form is a query that is based on tblA. The OnClose event of the popup attempts to change data in a text box on the access 2007 main form if certain changes have been made on the popup. Because both use the same data source I have tried saving the record before attempting to make the changes, I have tried refeshing both the popup and the main form. I have tried all of these save attempts in the following places: My own exit command button, form unload event, form deactivate event, form close event. access 2007 error I continue to get the "runtime error '-2147352567 (80020009)' The data has been changed." The part that boggles my mind the most is that if I setup a save button on the popup form and click that after making my changes and then close the popup it works perfectly. If I put in a break in the code and step through it, it works perfectly. Any help would be greatly appreciated. Bill Newtown PA Nov 12 '05 #1 Post Reply Share this Question 2 Replies P: n/a Albert D. Kallal I have a LOT of forms that call other forms based on the same data source. The trick is simply to make sure RIGHT BEFORE you launch another form, you force a disk write. That way, the current record is written to disk, and then here is NO pending write. You then simply launch that other form, in your case the popup. So. me.Refresh .....code to launch popup ..... popup form may modify data. .... popup form close We are back. The above should just work fine. So, the real "trick" is to ALWAYS write out the current record to disk RIGHT BEFORE you popup, or leave to another