Forum Discussion

morpheus73's avatar
morpheus73
Copper Contributor
Feb 16, 2023

VBA Modules Access no longer available

Hi everyone,

I have (maybe: i had) a file access with more VBA modules inside. The file is stored into a  OneDrive's location.

After a couple of moths I've opening the files to continue the programming activities and I've got a surprice. All modules are not longer available. I see it in the panel but whe I try to open it I've a message: The module name is wrong or it refers to a nonexistant module.

 

I contacted Microsoft support and I discovered a huge truth: There was never support for Microsoft Access.

 

Is there someone that had same problem and fixed it ?

  • George_Hepworth's avatar
    George_Hepworth
    Silver Contributor

    morpheus73 

    Re the apparent assumption that "There was never support for Microsoft Access." That may well be a misinterpretation, or perhaps even a bit of an exaggeration, of what you were told? 

     

    This error message generally means that the VBA project has become corrupted and is now unusable.

    Restore the most recent backup you have of this accdb.


    Stop trying to use Access accdbs from a OneDrive. You can safely store backups on OneDrive as long as you do not try to open and run them from there.

  • AccessVandal's avatar
    AccessVandal
    Copper Contributor
    Did you open from your "OneDrive" folder in PC or it is strictly on the web?

    You should be working on your local drive. OneDrive will update to the "OneDrive" cloud storage.

    There should be a special folder in your File Explorer on the left pane window.

    Just make sure you have the correct folder, my experience was on the wrong Folder/Files but not a corruption.

    Check the database file name extension. Is it "laccdb", "laccde"? Sometimes you might be open a compile version with full version of Access.

    If you can see it in the panel, can you try to export out to Access or as a Text file? Just right click on the VBA Module - Export
  • AccessVandal's avatar
    AccessVandal
    Copper Contributor
    Forgot about the OneDrive file recovery. Did you tried to use OneDrive to check for any files/folders that was deleted and recoverable?
    • morpheus73's avatar
      morpheus73
      Copper Contributor

      hi AccessVandal,

      Yes, I tried it. No history versions works fine. I've 4 versions of the file and it is very sospicious because if I have 4 history versions it could be possible that I worked on it before.... Or that I just opened the file asking OneDrive to create a version. I not understand.

      All that I know is that if I create a new module it works fine.

      Thank you in advance.

      • AccessVandal's avatar
        AccessVandal
        Copper Contributor

        morpheus73 

         

        No way of just reading from your reply. This is an issue with your OneDrive.
        Try OneDrive help.

         

        OneDrive Restore 

        OneDrive Restore Delete 

         

        I have no idea how it would work out until you try to Restore. Hopefully you could restore into a new folder and in a way you still have the old version. Try looking for help in OneDrive forum before your proceed.

        OneDrive Forum 

         

        Select the ComboBox (to filter) for OneDrive in that page to show all issues with OneDrive.

         

        It could have been OneDrive suffer a failure or something. Could be a disconnect between your usage during your work in Access. 

         

        It is strongly advised to work on your local folder and a manual backup. Copy and paste into the OneDrive Folder in Explorer when you are done.

         

        If you really can't work without OneDrive, you got to make sure you have a constant connection without a break from the OneDrive Cloud. If you by any chance see a disconnection, save the database file immediately into a Folder (Save As).

        HTH 

         

         

Resources