"Rick Brandt" wrote:

> Alex Lomaka wrote:
> > I created MDE database with all tables are hidden and "View hidden
> > object "option -unchecked. If I open this database using "Open with
> > ...Excel" option I  am able to see and open hidden tables.
> > Is anyone has the solution how to solve this problem and hide the
> > tables from any application? Looks like MDE doesn't work in this case.
> > Thank you.
>
> MDEs do not have "hiding tables" as one of their design goals.  If you want to
> protect tables then use User Level Security or switch to a server database like
> SQL Server.  Otherwise all you can do is obfuscate.  I doubt that opening an MDE
> file with Excel would occur to very many people.
>
> --
> Rick Brandt, Microsoft Access MVP
> Email (as appropriate) to...
> RBrandt   at   Hunter   dot   com
>
>
>