Split database

[reynier09]

Hi, I'm working on my company's database (Access 2010) and have a few questions. In one of the tables there's a field with confidential information which I'm trying to encrypt or avoid users to see. The table that contains this field is used throughout all the database by queries, forms and reports, but not the mentioned field. By now I have learned a bit about Access's limitations when it comes to security and I'm trying to come to a final idea about my need. I know I can hide the navigation panel, hide fields, ribbon, quick access, etc, but this won't deter a moderate and willing user. I know is SQL is perhaps a better option, but is not in the main menu I was given to work with. Now, about splitting the database:



If I put all my tables and queries in the back end, is there a way for a user to see that field I want to hide? I mean, can they get to that field if it's not used in any query, form, report?

Now, for the SQL part. I just started learning it and I used the Upsize wizard but when I open the database in Management studio I only see the cells as read only, how am I able to edit this.

Also, if I put the back end in the SQL server, will I still be input data there? I just need users to input some data from forms and the confidential from the back end, is this possible?
Thanks

[ranman256]

You don't put queries in the backend. Everything goes in the front, except tables.
it will work the same as if not split.

[reynier09]

Thanks.
So, would my tables in the BE be safe if I put it in folder with restricted access?
Why my tables show as read only in SQL server after up sizing?

[John_G]

If I put all my tables in the back end, is there a way for a user to see that field I want to hide? I mean, can they get to that field if it's not used in any query, form, report?

Yes. If users can see the table, they can see all the fields in it.

However -

So, would my tables in the BE be safe if I put it in folder with restricted access?

Assuming your network security works as it should, yes. Even if a user without network access permission to the tables opens the front end, they still won't be able to see the tables.