Hiding data in Access

[ypper2001]

Can anybody point me in the right direction?
I have created a small db that I am distributing to the people I work with.
It is a read only db with some what sensetive informasjon if you could pull out large amount of data.
My problem is that by using import in Access you can pull out the data in the tabels.

Is there a way of hiding the Tabels?

[ADezii]

Can anybody point me in the right direction?
I have created a small db that I am distributing to the people I work with.
It is a read only db with some what sensetive informasjon if you could pull out large amount of data.
My problem is that by using import in Access you can pull out the data in the tabels.

Is there a way of hiding the Tabels?

There are 2 Methods for 'hiding' Tables in Access:

1. Preface the Table Name with 'MSys' as in MSysEmployees. Access will interpret these Tables as System Tables, and not display them in the Database Window by default. If Users have access to Menus, however, they can reverse this action via Tools ==> Options ==> View ==> System Objects.
2. Select Table ==> Right Click ==> Properties ==> Select Attributes: Hidden. This can also be reversed in a similar manner.

[missinglinq]

As ADezii indicated, no matter how clever a mousetrap you devise, there's always going to be a smarter mouse out there! All you can really do is make it harder for your data to be hijacked!

Assuming that you could make your tables inviolate, users who can view the data can still do a Print Screen to grab the data or a copy and paste. Ultimately, you have to trust the people who are given access to your data!

Linq ;0)>

[ypper2001]

Thanks for the hints and for the advice. I will try this out and se if it serves my purpose. Thanks again.

[NeoPa]

You can also look in the Startup Options (Tools / Startup...) to ensure the Database window is not shown by default and some other options in there for extra security.