Results 1 to 5 of 5
  1. #1
    tcox's Avatar
    tcox is offline Advanced Beginner
    Windows 7 64bit Access 2013
    Join Date
    Oct 2015
    Posts
    46

    DB corrupted?


    I'm now presented this message when clicking on any of my list boxes.
    Click image for larger version. 

Name:	access error.jpg 
Views:	7 
Size:	88.2 KB 
ID:	22515

    This started happening when after I saved some VBA code in a function and Access alerted me that another user had edited the form and asked to save those edits. I was like , but I thought erroring on the safe side would be to save the edits.

    Code:
    Private Sub txt_SubassemblyNotes_Click()
    DoCmd.RunCommand acCmdZoomBox
    End Sub
    Fairly innocuous code.

    what has happened and where do I start to fix this?
    My form was working perfectly until now!

  2. #2
    tcox's Avatar
    tcox is offline Advanced Beginner
    Windows 7 64bit Access 2013
    Join Date
    Oct 2015
    Posts
    46
    I have tried the fix of copying the affected form, deleting the original and then renaming the copy to the originals name.. no joy

  3. #3
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    Is this a multi-user db? Is it a split design?

    Exactly what is in the OnChange event property of comboboxes? I don't use OnChange event. I use AfterUpdate.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  4. #4
    tcox's Avatar
    tcox is offline Advanced Beginner
    Windows 7 64bit Access 2013
    Join Date
    Oct 2015
    Posts
    46
    Looks like I fixed it. I copied all the controls in the form and moved them to a new blank form, then copied all the corresponding vba code over. It all works now. Crazy!

    Really makes me wonder whats going on in the background with two identical forms, one worked, broke, and the copy works flawlessly.

    Apparently this random corruption has been happening since Access 2007.

    To answer your question June7, this is not a multi-user db, or split design. Just developing this on my terminal at work.

    The code in the OnChange is:
    Code:
    Private Sub CBO_CapSize_Change()
    Me.CBO_Part_Set.Requery
    Me.CBO_Part_Set.Value = ""
    End Sub
    
    
    Private Sub CBO_Machine_Type_Change()
    Me.CBO_Part_Set.Requery
    Me.CBO_Part_Set.Value = ""
    End Sub
    
    Private Sub CBO_Part_Set_Change()
    Me.TXT_AssemblyID.Requery
    DoCmd.Requery "Q_Subassemblies_SubF"
    End Sub
    these work together for the selections that narrow down the results for the comboboxes.

  5. #5
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    What it sounds like is that the VBA project was slowly going bad (corrupting).

    I had this happen in A2K. I made a lot of changes without doing a Compact & Repair.
    My rule now is: Compact often..... Save often.
    This means saving about every 5 minutes. Compact & Repair about every 10 lines of code added, deleted or changed.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Database Corrupted?
    By knowshowrosegrows in forum Access
    Replies: 2
    Last Post: 09-23-2015, 09:16 AM
  2. Databases Keep Getting 'corrupted'.
    By Robeen in forum Access
    Replies: 24
    Last Post: 09-20-2013, 09:32 AM
  3. Certain fields get corrupted
    By MarDude in forum Access
    Replies: 22
    Last Post: 04-19-2013, 06:34 AM
  4. Access is Corrupted
    By waqas in forum Forms
    Replies: 4
    Last Post: 10-16-2011, 01:23 PM
  5. Database Corrupted
    By waqas in forum Forms
    Replies: 3
    Last Post: 09-14-2011, 01:35 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums