Need Help To Create a MDE with certain Items Available

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gary - 31 Oct 2006 18:31 GMT

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

Reply to this Message

Rick Brandt - 31 Oct 2006 19:22 GMT

> I have an Access 2000 database. There is no front or backend to this.
>
[quoted text clipped - 6 lines]
> still don't want any of my VBA code available. I would like the MDE
> to have it removed.

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.

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Reply to this Message

Granny Spitz - 31 Oct 2006 19:41 GMT

> I can see the Reports or VBA codes.

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.

> 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???

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.

> I still
> don't want any of my VBA code available. I would like the MDE to have it
> removed.

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.

Reply to this Message