I have an Access 2000 database.  There is no front or backend to this.

I have been using the tools in creating a MDE database from MDB.  When I
open the MDE in an Access Application, I am still able to see the Tables,
Queries.  I can see the Reports or VBA codes.

Is there a way for me to create a MDE database that will also make the
Reports availble (in addition to the Tables and Queries) only???   I still
don't want any of my VBA code available.  I would like the MDE to have it
removed.

Can someone please help me!

Thank you,

Gary

Gary wrote:
No, an MDE locks down all "code based objects" and that includes forms and
reports.  The reason Tables and Queries are still editable is because they
are not code-based.

Gary wrote:
Converting to MDEs removes the VBA code.  If you can see the VBA code or
press the design view button (meaning it's not disabled), you have an MDB
file, not an MDE, even if the extension is .mde.

You'll have to keep the reports in an MDB file and link to the tables if you
want to be able to make major design changes or change the code.  But if you
want to change minor things on the report design, like move or remove text
boxes and labels or change properties, you can keep the reports in an MDE and
make these design changes.  You can't change the code or add controls though.
But if there's no code for the report you can add new controls in an MDE.

If you want to remove the code, put the object in the file that's going to be
converted to an MDE.  You can't have it both ways.  Something you can do is
have the code in the reports only call library functions and have those
library functions in your MDE, but this isn't easily deployable.

How do I assign a digital signature to an MDB on our network?
using the opencurrentdatabase in script
No exclusive access
Mdw file not found
how do i unlock my document
How to access a linked table from one secure database to another
Multi-Users - Security
secured database can be opened
Securing the back end of the database
Acess DB Corrupted HELP