I have a MS Acces database containing login information to the database file in a created table called "USys1Empoyees".
Off course it is set as hidden in table properties.
However, when I approach the data through excel by GET DATA > From ms acces database file
This table is exportable including the login's and passwords...
I've hidden most of the tables which work fine. But there are 3 tables I am unable to restrict and still show up in the GET DATA function in Excel.
Is there anyway to actually hide them? What am I missing?
Thanks so much!
Only difference between the tables that I could hide and not hide from GET DATA. Is that the tables that I am unable to hide. Where created tables within MSAcces and are not linked tables to the SQL server.