Forum Discussion
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_HepworthSilver Contributor
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. - AccessVandalCopper ContributorDid 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 - AccessVandalCopper ContributorForgot about the OneDrive file recovery. Did you tried to use OneDrive to check for any files/folders that was deleted and recoverable?
- morpheus73Copper 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.
- AccessVandalCopper Contributor
No way of just reading from your reply. This is an issue with your OneDrive.
Try OneDrive help.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.
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