Can't Create MDE

[TheSearcher]

Hello All,
I'm using Access 2010 and my code compiles okay but when I hit the "Make MDE" button nothing happens - not even an error message. Has anyone experienced this?
Thanks in Advance,
TS

 

[TheSearcher]

Hi Bob,
Thanks for replying. Where is the "VBA Window"? Do you mean the Immediate Window? I don't see any options anywhere for Debug --> Project.
Thanks,
TS

 

[TheSearcher]

Thanks Bob. That's what I thought you meant but there is no Debug --> Project option. Also, when I open the database, although I am using Access 2010, the upper ribbon displays (Access 2002 - 2003 File Format). Can that have anything to do with why I don't see the Debug --> Project option?

 

[PeterF]

As far as I know it's not possible to create a mde in Access for a previous version of Access.

 

[TheSearcher]

Wow PeterF - if that's true it certainly would have saved me much time had they placed a message box behind the "Make MDE" button notifying me that it could not be done. How can I work around this? I need to secure this app.
Many Thanks,
TS

 

[TheSearcher]

No problem Bob. I did succesfully compile the program using the steps shown in your screen shot. Attached is a snapshot of the "Make MDE" button. Thanks for your help!

 

[TheSearcher]

Bob - Thanks for your efforts. There are two segments of my app. I have the back end in an mdb file. This contains only the tables. I have the front end also in an mdb file. This contains all of the code, forms, reports etc. Does this add anything new to the picture?
Thanks,
TS

 

[TheSearcher]

Yes. I am trying to make an MDE for the front end. However, now that I think about it, I would like to protect the data in the tables as well. I would not want users to be able to access this.

 

[TheSearcher]

Okay, so for now I will stay focused on the front end. I will need to get my "Make MDE" button to work. I will continue to search. Please let me know if you come up with anything in your research. Your help is greatly appreciated.

 

[TheSearcher]

This is interesting - I created a blank 2010 database, imported all of my objects into it, compiled it and created an accde file successfully. However I can still go to design view in forms and reports by right clicking the mouse. A user can then modify these objects. So, what good does the accde file do for me??

 

[TheSearcher]

Apparently I did not. Sorry about that. It seems to be working fine now in 2010 but I'm not certain that all of my clients computers have 2010 installed. I guess I'll begin looking into the runtime. Thanks for all of your help with this and for your patience!