Database cannot be opened because the VBA project contained in it cannot be read

Question

Learning from "Microsoft Access 2019 Bible". The Subject line is the error I get when I try to do something in the file for chapter 20. Below in the entire msg. How do I delete this project and will that have an effect on the rest of the examples in the Chapter? Thank you

Answer 1

Using Alt + F11 I was able to open VB Editor and I closed all the code windows. This seems to have solved the problem. I guess I shouldn't be so quick to cry help.

Answer 2

Not sure exactly what I'm talking about here but while the database opens it looks like all the code in the VBA project is erased. When I try to open the report mentioned in one of the error msgs that's when I get that error msg about backing up the database. I have left 'Feed Back' on the Wiley website requesting them to have the author of the book correct the problem. Can only hope and wait patiently to see if the problem is solved. I wonder if I'm the only one to have gotten this far in the book or if this is a problem unique to me and my computer. I say this because I continue to have problems with Outlook 2019 and my Comcast email address. I use the Control Panel email app to enter the password I use on the Xfinity website, and all is well for a while. Then a few hours later, maybe the next day, I start getting these popups from the side of the screen that say 'You Comcast email information is out of date." I go through the same motions, using the same password, and again all is well for a while. It is very hard to get a live person at Comcast and I don't think they have any idea how to fix this problem and trying to contact Microsoft support? Haven't figured that one out yet. My hope is that someone on this site has connections to Microsoft and can tell me what I need to do to fix this problem. Office 365 doesn't come with Access. I thought about subscribing to 365 but I need Access. I'm thinking that I'm being forced to use the Comcast website for my email and remove Comcast email from Outlook. Also, I tried to put a gmail address in Outlook to no avail. Outlook cannot connect to gmail servers. The last time I tried to REPAIR Microsoft Office Profession Plus 2019 using the web option the entire Suite of programs was removed from my computer. I have a legal copy.

Answer 3

You're barking up the wrong trees.

As Tom and I said, this is a corrupted accdb file on your computer. It happens.

It's one copy of the accdb you are working with. Get a clean, new copy, either from one of your backups, or perhaps retrieve a new copy from wherever you obtained it originally.

Your Outlook problems are a totally separate issue; nothing to do with this one corrupted accdb. I have seen that same cycle of "password being dropped" by Outlook for specific email accounts. It was episodic and hasn't recurred for many months now, though.

I can't address your other issue with the repair going wrong because that's also quite specific to your computer and software.

Returning to the original point. Sometimes VBA in accdbs does get corrupted. That happens, I suspect, in cases where you are actively modifying functions or subs while another function or sub is running, i.e. when the code goes into break mode. It is not highly predictable, but the correlation between making changes on the fly while in break mode and corruption is quite high. The solution is to make regular, frequent backups and be prepared to use them. Or, exercise greater discipline while modifying code.

Answer 4

I Agree: very lucky. Make sure you step up your backup procedures.

Answer 5

You are probably lucky. That error message is usually seen when an accdb is corrupted beyond recovery.