VBA crashes Access

[TheShabz]

Hi everyone,



I was working on a database yesterday that worked fine. This morning, opening a form would cause Access to crash. I opened the form up in design view and nothing happened. I closed it and then opened up the VBA editor and it crashed. It was working fine yesterday and there have been no changes to the DB (stored locally on my machine that nobody else has access to) since then. I've run compact and repair and the problem persists. Any ideas before I port my forms over to a new DB and rewrite my code?

[RuralGuy]

Just try *importing* you db into a fresh new db and see if the problem follows. It just takes seconds.

[John_G]

Was there any error what you saw before it crashed? Are to able to open and edit code modules (outside of forms/reports)? If the VBA is causing to it crash, it sounds like there might be a missing or corrupted .dll file.

John

[TheShabz]

VBA opens fine in another db. Trying to import the forms to a fresh db causes the new db to crash as well. I don't have any complicated code in there. Everything is self-contained. No shell calls or anything of the sort. It's basically If/Then and query sequences.

[RuralGuy]

VBA opens fine in another db. Trying to import the forms to a fresh db causes the new db to crash as well. I don't have any complicated code in there. Everything is self-contained. No shell calls or anything of the sort. It's basically If/Then and query sequences.

You can *import* one object at a time until you find the corrupt object, which would probably be easier than recreating everything from scratch.

[TheShabz]

I did. There are only 3 forms, one of which is a navigation form. Both the forms with VBA behind it crashed, as did my module. It's not a big deal to recreate. I'm more interested in the cause than a way to use them again.

[RuralGuy]

I'm more interested in the cause than a way to use them again.

I understand and do not have any more suggestions. It sure sounds like everything is now toast. Maybe it has something to do with the 64 bit Access??? Sorry. If you want to zip it up and post I could try it with my 32 bit Access and see if I get the same results.

[TheShabz]

Would love to post but that would probably lead me to getting fired. I'll just file this under "shit happens" and leave it at that.

[RuralGuy]

Ain't computers wonderful??

[TheShabz]

Found the solution. looks like it's not just me. There is a hotfix available and will be included in SP2, whenever that is.
http://answers.microsoft.com/en-us/o...0af271b?auth=1

The workaround for now is to Run>PathToACCDB /decompile, close Access, and open it again.

[RuralGuy]

Thanks for the heads up Shabz!