MrDavidThorn
asked on
Ms Access Compiles without VBA code
Hi Experts
I have an Access Datafile with some VBA forms and code, when I "Make MDE" file with the Datafile it creates the MDE file ok, but when I launch the MDE file it appears that no VBA code has been included with the build.
Is there anything that I might have missed?
I can compile the code via VBA debug menu with no problems.
I have an Access Datafile with some VBA forms and code, when I "Make MDE" file with the Datafile it creates the MDE file ok, but when I launch the MDE file it appears that no VBA code has been included with the build.
Is there anything that I might have missed?
I can compile the code via VBA debug menu with no problems.
ASKER
Its not working, I think it may be do with the Signature.
Try decompiling your MDB file and recompiling as described here ...
http://stackoverflow.com/questions/3266542/how-does-one-decompile-and-recompile-a-database-application
Or here
http://social.msdn.microsoft.com/Forums/office/en-US/72b842b0-86a0-4476-afc3-ae9d5ea740ff/decompile-steps-for-mdb?forum=accessdev
Well described here ....
http://forums.databasejournal.com/showthread.php?34222-Decompiling-VBA-code-in-an-Access-mdb-file
Routine decompiling is almost as important as routine compacting.
(If you are trying to run the MDE file on another PC there could be library issues).
http://stackoverflow.com/questions/3266542/how-does-one-decompile-and-recompile-a-database-application
Or here
http://social.msdn.microsoft.com/Forums/office/en-US/72b842b0-86a0-4476-afc3-ae9d5ea740ff/decompile-steps-for-mdb?forum=accessdev
Well described here ....
http://forums.databasejournal.com/showthread.php?34222-Decompiling-VBA-code-in-an-Access-mdb-file
Routine decompiling is almost as important as routine compacting.
(If you are trying to run the MDE file on another PC there could be library issues).
More then likely, it's "macro" security that is stopping the DB from executing. It must be in a trusted location, or the macro security level must be set to low.
If it made a MDE successfully, then I doubt there is a problem with the code.
Jim.
If it made a MDE successfully, then I doubt there is a problem with the code.
Jim.
ASKER
Im testing with a form that just displays a simple msgbox when the db is loaded, works before the code is published but not in the MDE file. The code is not digitally signed, but in [Access Options],[Trust center],[Trusted Publishers] their is a list of valid publishers. Would this have an impact?
This app is a for a global business so they have more than likely got some global setting that is not validating the MDE
This app is a for a global business so they have more than likely got some global setting that is not validating the MDE
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
No code is visible within a MDE file.