Ms Access Error 7878 Data Has Been Changed
Social Groups Pictures & Albums Members List Calendar Search Forums Show Threads Show Posts Tag Search Advanced Search Find All Thanked Posts Go to Page... Thread Tools Rate Thread Display Modes 09-07-2008, 08:07 AM #1 Mikahell Registered User Join Date: Sep 2008 Posts: 3 Thanks: 0 Thanked 0 Times in 0 Posts Error 7878 (data has been changed) Hi all, I'm having this problem with error 7878, which from other posts I have seen would be an error occuring when 2 users edit the same data at the same time. However, I'm currently developping so I am the only one in the database, always. I'm trying to send the value of the primary key in some form to a parent form which will receive it in a foreign key field. On my first described form, when I click a button, it closes the form and send in a global variant the value of the textbox representing the primary key, so the other form can receive it. It works great, unless I edit data in the first form and exit the form without firstly clicking the record selector control to save the modified data (generates error 7878). I got desperate and tried various things to force access to save the current record before closing the form, but the error persists. I have tried including in my close button click's event procedure combinations of all the following, but the error still persists : DoCmd.Save RunCommand acCmdSaveRecord Me.Requery Me.Refresh DbEngine.Idle dbRefreshCache Sleep(1000) From what I understand, the saving of the record really happens (one would hope, after calling so many kind of save functions) but it "happens" only after the button's event is finished... But since the form closes in the button's click, the data is "being saved but not really completed". If I can be clearer, I think that the form's record is only saved once all user-functions stack are done and that the focus is sent back to the form, or so... I suppose it works this way, and I wanted to know if there's a kind of method to pause the execution of the current event and force the refreshing of the form (like a multi-threaded app would wait until one process is completely finished before continuing another task), so that the form would really get to "Me.Dirty = False" state before the form closes, avoiding error 7878. I've heard multithreading in access is impossible, but I don't believe it, since I have seen a user progressbar control (wish I had the code -_-) that does a loop of actions and increments the progressbar's filling to the right and we can see it filling slowly to the end. I believe that means that there IS a way to update the form even if code is still running in background. Hope all is cl
help? Post your question and get tips & solutions from a community of 418,595 IT Pros & Developers. It's quick & easy. Error - The data has been changed P: 31 philelpko Afternoon all, Cheers to anyone who can help! So far this forum has been a big lifeline to me!! I believe this to be the last hurdle before my database is complete! Problem - I have a main form with 3 subforms. Each subform is hidden until it is made visible through use of a check box (code has been written to only allow one box to be visible at any one time). These http://www.access-programmers.co.uk/forums/showthread.php?t=156464 had been working perfectly but all of a sudden I have begun to get the error message "The data has been changed. Another user edited this record and saved the changes before you attempted to save your changes" This is hard to believe as i am the only person using the database. I have found a few articles relating to this but no-one ever suggests a possible fix for this problem. The Microsoft site https://bytes.com/topic/access/answers/571314-error-data-has-been-changed says to fix the problem to add "Me.Parent.Requery" to the AfterUpdate event on the subforms. This does work but now when you try to change subforms using the check boxes, the 1st click on a check box appears to trigger the AfterUpdate but then you have to re-click the same check box to acctually change forms. i.e. to change to Travel Subform from Cars you have to click the Travel Check Box, wait a second or two, and then click the Travel Check Box again to actually get it to change. Seems a little pedantic i know but it just makes the form non user friendly. Open to suggestions!! Cheers. Nov 30 '06 #1 Post Reply Share this Question 22 Replies Expert Mod 10K+ P: 14,534 MMcCarthy In Tools - Options under the Advanced tab. Is your Default Record Locking set to Edited Record? Is Open databases using record-level locking ticked? Nov 30 '06 #2 reply P: 31 philelpko Default Record Locking is set to "No Locks" The Open databases using record-level locking is ticked. Nov 30 '06 #3 reply Expert Mod 10K+ P: 14,534 MMcCarthy Default Record Locking is set to "No Locks" The Open databases using record-level locking is ticked. Change Default Record Locking set to "Edited Record" and comment out the Me.Parent.Requery code. Does this solve t
be down. Please try the request again. Your cache administrator is webmaster. Generated Wed, 19 Oct 2016 08:11:01 GMT by s_ac4 (squid/3.5.20)
Unanswered Topics Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA Runtime Error 7878 Data has been Changed User Name Remember Me? Password Reminder Password Register Register | FAQ | Members List | Calendar | Today's Posts | Search Access VBA Discuss using VBA for Access programming. Search Forums Show Threads Show Posts Advanced Search Find All Thanked Posts Go to Page... Welcome to the p2p.wrox.com Forums. You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free . Thread Tools Display Modes #1 (permalink) May 22nd, 2008, 09:08 AM ayazhoda Friend of Wrox Join Date: Apr 2007 Location: , , . Posts: 110 Thanks: 1 Thanked 2 Times in 2 Posts Runtime Error 7878 Data has been Changed Hi All I have Me!TotalExist (which Calculate total of all items in sub from) in Form A And Me!Price exist in SubForm When Me!Price Updated in subform Than Button_1 is Clicked to Calculate all Items Value RunCommand acCmdSaveRecord variable_X= Function_1(Arg 1, Arg 2, Arg 3) Me!TotalExist= variable_X Runtime Error 7878 Data has been Changed Any help Thanks « Previous Thread | Next Thread » Thread Tools Show Printable Version Email this Page Display Modes Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is Off HTML code is OffTrackbacks are Off Pingbacks are On Refbacks are Off Similar Threads Thread Thread Starter Forum Replies Last Post DetailsView: chk 4 changed data before modechange? ledneh ASP.NET 2.0 Basics 0 December 18th, 2007 06:00 PM track page data has changed webmahesh XSLT 1 December 12th, 2007 05:54 PM How to check whether page data has changed webmahesh JSP Basics 0 December 12th, 2