Problems with ACCDE Database

[michaelb]

I have a database that works fine as a ACCBD, but when I make a ACCDE from the ACCBD, the ACCDE does not recognize the VBA code attached to any of the events. I know it is not recognizing or accessing the VBA code because in the ACCDB I put a msgbox to display the message "VBA Code Accessed". When I run the ACCDB, the message box displays the message. When I run the ACCDE, it does not. I have a combobox in a form. I also used a msgbox to display the record number for the name selected in a combobox; msgbox(Me!Combo0). In the ACCDB it worked fine. In the ACCDE it did not. I don't know what to do from here. I need help. It is my hope that someone else has been through this. If you can give me suggestions on cause or action to take, I would appreciate it.



Thank you...

[RuralGuy]

Is the DE in the same location (folder) as the DB?

[michaelb]

Thank you RuralGuy for replying.

Yes, The DE is in the same location as the DB.

[RuralGuy]

I was just guessing that maybe the DE was not in a trusted location. I don't know why it would not work if they are both in the same location.

[michaelb]

If you think of anything that might be helpful, let me know.

Thanks again

[RuralGuy]

I've not played with DE's before but if you want to post your db then I'd be willing to give it a shot. Compact and Repair first before zipping up the db. Include both the DB and DE if you post.

[rpeare]

Are you opening both files from the same computer?

Or are you attempting to open the accde from a different computer?

You may also need to check security settings, macros/module code will not run in certain instances with accde(or .mde) files.

[michaelb]

Thank you Rural Guy and repeare, The ACCDB to ACCDE problem has been fixed. I had to compile the ACCDB before the DE would work. From within the VBA editor, I clicked on the DEBUG option which showed the compile database option. Once compiled it workd fine. Thanks again for all your help.

michaelb

[RuralGuy]

Thanks for posting back with your success.