Hiding tables in MDE files

[Charles Tam]

Is there a way to hide tables in MDE file, such that, they could not be
imported or linked to a separate mdb file.

I've set the table's hidden property, however, it does not seem to work. Any
ideas?

 

[Rick Brandt]

Is there a way to hide tables in MDE file, such that, they could not be
imported or linked to a separate mdb file.

I've set the table's hidden property, however, it does not seem to work. Any
ideas?

You can "obscure", but the only way to prevent is to use Access User-Level
security (an advanced topic). Even that can be hacked so it depends on
whether you want to keep out the "casually curious" or the "truly
malicious". If the latter the data doesn't belong in an Access file.

 

[Charles Tam]

Thanks for your information.

You can "obscure", but the only way to prevent is to use Access User-Level
security (an advanced topic). Even that can be hacked so it depends on
whether you want to keep out the "casually curious" or the "truly
malicious". If the latter the data doesn't belong in an Access file.