I have the ODE tools, and need to make a runtime version of my Access 2000 database...<br><br>Firstly, I made the runtime version using my MDB file. All fine...<br>Then I tried to make a runtime version of my MDE file..But I can't because MDE's have no modules, thus I cannot get to the Visual Basic Editor that comes with Access 2000. Hence, I cannot run time Package and Deployment Wizard addin to make the runtime file.<br><br>How do I create a runtime version of an MDE file?????<br><br>Thanks,<br><br>Jake.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Access 2000 MDE to Runtime
- Thread starter jacobl
- Start date
Why do you need to get the a module of an .MDE<br>
Do everything in the .MDB add you code or whatever.<br>
Get it all working then make a .MDE out of it.<br>
<p> DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br>
Do everything in the .MDB add you code or whatever.<br>
Get it all working then make a .MDE out of it.<br>
<p> DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br>
- Thread starter
- #3
DH
Programmer
- Dec 8, 2000
- 168
I have encountered the same problem and have found this solution.
1.) Create a SECURE .mdb file. Lock it down so that end users cannot get into your file. Lock your project file, disable the allow bypass key (Shift), and create your own right click shortcut menu so the end user cannot get to "design".
2.) Create a new toolbar with the "Show VB Window" command on it.
3.) Create a macro to show the new toolbar you just created.
4.) Create a hidden button/text box on your opening database form so that when you double click it it will show the new toolbar you just created that has the VB command on it that will open the Visual Basic Editor.
5.) Once you open the Visual Basic Editor minimize it monetartily and close the VB toolbar on your application.
6.) Maximize the VBE and run your package and deployment wizard.
You've just created a secret backdoor into VBE.
DH
1.) Create a SECURE .mdb file. Lock it down so that end users cannot get into your file. Lock your project file, disable the allow bypass key (Shift), and create your own right click shortcut menu so the end user cannot get to "design".
2.) Create a new toolbar with the "Show VB Window" command on it.
3.) Create a macro to show the new toolbar you just created.
4.) Create a hidden button/text box on your opening database form so that when you double click it it will show the new toolbar you just created that has the VB command on it that will open the Visual Basic Editor.
5.) Once you open the Visual Basic Editor minimize it monetartily and close the VB toolbar on your application.
6.) Maximize the VBE and run your package and deployment wizard.
You've just created a secret backdoor into VBE.
DH
DH, I like your solution! However there may be an easier way unless you have disabled the "bypass key". Do you have a startup form instead of a typical database window running at startup? The autoexec macro causes the main database window to remain hidden and open your startup form. There are modules in an .MDE file, it's just that they are compiled and there is no way to view the code in them. The easy way around this issue is to use the "by-pass" key when opening the .MDE file.
Just after clicking the .MDE file to open it, press and hold the "Shift" key. This will prevent the autoexec macro from running and opening the startup form. You will open the database to the database window and the default menus. Now you will be able to open the Visual Basic Editor from the "Tools" menu or pressing the shortcut keys "Alt+F11". Then you will see the Addins menu to run the Package and Deployment wizard.
Bryan Meek
bmeek@pacbell.net
A "Solution Provider" in your corner gives you the personal attention you need to find the right technology solutions for your business.
Just after clicking the .MDE file to open it, press and hold the "Shift" key. This will prevent the autoexec macro from running and opening the startup form. You will open the database to the database window and the default menus. Now you will be able to open the Visual Basic Editor from the "Tools" menu or pressing the shortcut keys "Alt+F11". Then you will see the Addins menu to run the Package and Deployment wizard.
Bryan Meek
bmeek@pacbell.net
A "Solution Provider" in your corner gives you the personal attention you need to find the right technology solutions for your business.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question