Results 1 to 3 of 3
  1. #1
    Bcanfield83 is offline Advanced Beginner
    Windows 7 32bit Access 2016
    Join Date
    May 2018
    Posts
    81

    Question Modules Suddenly Missing?

    Hi All,
    I recently got an upgraded laptop with Windows 10 (64-bit) - previously was using Windows 7 (32-bit). Over the past couple days, my Access DB (.accdb file) keeps getting corrupt.. seems like whenever I modify something in the VBA Editor (in a Module or Class Module), the dreaded, "Database is in an inconsistent state" error will come up shortly thereafter. Thus far, it's able to repair the database each time - but prior to getting a new laptop, this never occurred.
    Yesterday I ended up creating a brand new ".accdb" file and then importing all of the Forms/Queries/Reports/Modules from a backup version. The tables are all linked to a separate backend ".accdb" file (split database).
    Currently I'm running into an issue where the modules are all listed in the Object Explorer, but then if I right-click on any of them and select "Design View", I receive the below error:
    "The module name <xxxxx> is misspelled or refers to an object that doesn't exist".



    If I go into the VBA Editor window, all of the Class Modules and Modules are missing.. They were there earlier this morning, but missing ever since I did another repair earlier today. Thoughts??

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,550
    This happen occasionally. Access 'crashes' and wipes out the entire VB code.
    you must restore from a backup. (not the vb, restore the entire db)

  3. #3
    Bcanfield83 is offline Advanced Beginner
    Windows 7 32bit Access 2016
    Join Date
    May 2018
    Posts
    81
    I was able to restore them, though it seems that the "FE" database keeps getting corrupted ever since I received my new laptop.
    Both the FE and BE .accdb files are on a network shared drive. There's a total of 3 people that use the database - but when opening it, I have a custom ".vbs" script (that I stole from somewhere) which creates a copy of the ".accdb" file under their UserID. So there's never more than 1 person in the main "FE" database at a time.
    The other 2 people are also running this on Windows 10. The OS itself is the 64-bit version, but it's running the 32-bit version of MS Office. The FE and BE files were created by me using Windows 7 (32-bit version). Could there be compatibility issues there?
    Yesterday I created a brand new ".accdb" file (on my new Windows 10 laptop) to use as the FE, then imported all of the objects over from the existing FE ".accdb" file. Then, linked all of the tables to the existing BE database. Yet it seems to keep getting corrupted (or on the verge of it - as per the "database is in an inconsistent state" error), like clockwork. This never happened until I started using the FE on my new Windows 10 laptop, so I'm thinking it must be some issue with that.. just can't figure out what it is specifically!

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

Similar Threads

  1. When to use modules?
    By Paowtrick in forum Access
    Replies: 7
    Last Post: 11-06-2018, 06:21 PM
  2. When to use standard modules vs. class modules
    By Access_Novice in forum Programming
    Replies: 7
    Last Post: 01-03-2016, 10:47 PM
  3. Form view suddenly gone?
    By DWEvans in forum Access
    Replies: 2
    Last Post: 11-18-2015, 10:34 AM
  4. form is suddenly read-only
    By Karen H in forum Forms
    Replies: 28
    Last Post: 02-14-2011, 08:38 AM
  5. How to use Modules
    By wasim_sono in forum Access
    Replies: 0
    Last Post: 01-16-2007, 06:29 AM

Tags for this Thread

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