Hide table designs and relationships?

[Max Moor]

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

 

['69 Camaro]

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=en&lr=&ie=UTF-8&c2coff=1&th=38427923c78c24e6&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]

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=en&lr=&ie=UTF-8&c2coff=1&th=38427923
c78c24e6&rnum=1

Got it. I guess it makes sense enough.

Thanks, Max