I can see hidden MDE tables using "Open with Excel". How to fix?

[Guest]

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.

 

[Rick Brandt]

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.

 

[Guest]

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.