Need Help To Create a MDE with certain Items Available

[Guest]

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

 

[Rick Brandt]

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.

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.

 

[Granny Spitz via AccessMonster.com]

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.