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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
Alex said:
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.
Click to expand...

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 said:
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.
Click to expand...
 
Back
Top