Code compiles, mde creation fails

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DFS - 13 Dec 2005 16:43 GMT

The .mde creation just sits there, until I click on the blank screen and I
get a (Not Responding) message in the title bar.

The code compiles fine. Other systems of a similar large size compile and
.mde create fine, so I think it's not Access but something in this .mdb.

Any ideas?

Thanks

Reply to this Message

Karen Hill - 13 Dec 2005 19:09 GMT

> The .mde creation just sits there, until I click on the blank screen and I
> get a (Not Responding) message in the title bar.
[quoted text clipped - 5 lines]
>
> Thanks

Yes. This happened to me also. The reason it happens is when you code
in VBA in access and have Events assigned to controls that don't exist,
or forms that you renamed. Cleaning up your vba code will allow you to
compile into an mde.

For example, In my case, I started out with a button named "button_34"
Which I added an Event "On Click". I then renamed button_34 to
something more meaningful, and added the new "On Click" method. Yet
the old button_34 code was left in the vba source, and hence I could
not create an mde. When I removed the unsused button_34 code, mde
creation worked.

Reply to this Message

DFS - 14 Dec 2005 03:29 GMT

>> The .mde creation just sits there, until I click on the blank screen
>> and I get a (Not Responding) message in the title bar.
[quoted text clipped - 18 lines]
> hence I could not create an mde. When I removed the unsused
> button_34 code, mde creation worked.

That did it. I found 4 one-line "orphaned" routines in my main interface.
Deleting them let me create the .mde.

Thanks

Reply to this Message