Hi All,

I have a database app that I want to distribute. I've created MDE files
for the front and backend. Even though the code is hidden, if I open the
DB in Access (as opposed to the run-time) I can still see the table designs
and the relationships.

Although this isn't as critical as the VBA code that makes them do
wonderful things, I'd still rather that these be hidden. Is there a simple
way to do this?

- Max

Hi, Max.

> I've created MDE files
> for the front and backend.

To make programming maintenance easier, Access developers generally leave
the back end as an MDB file, since the only thing in the back end should be
the tables and relationships, not the database application objects that are
protected in the front end MDE file.

> if I open the
> DB in Access (as opposed to the run-time) I can still see the table
designs
> and the relationships.
> I'd still rather that these be hidden. Is there a simple
> way to do this?

A similar question was asked last week. Here's the Google archive Web page:

http://groups.google.com/groups?hl=e...78c24e6&rnum=1

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)


"Max Moor" <maxmoor@remove_hotmail.com> wrote in message
news:Xns956326B17C80maxmoorhotmailcom@207.46.248.16...
> Hi All,
>
> I have a database app that I want to distribute. I've created MDE files
> for the front and backend. Even though the code is hidden, if I open the
> DB in Access (as opposed to the run-time) I can still see the table
designs
> and the relationships.
>
> Although this isn't as critical as the VBA code that makes them do
> wonderful things, I'd still rather that these be hidden. Is there a
simple
> way to do this?
>
> - Max

> To make programming maintenance easier, Access developers generally
> leave the back end as an MDB file, since the only thing in the back
> end should be the tables and relationships, not the database
> application objects that are protected in the front end MDE file.

Good point.

> http://groups.google.com/groups?hl=e...=1&th=38427923
> c78c24e6&rnum=1

Got it. I guess it makes sense enough.

Thanks, Max