Link tables limitations - security question

[Kamil]

Hi.
I have 2 databases:
A) Personel.mdb
B) Contracts.mdb
A can be edited by HR, B by ADMINISTRATION.
There are security settings on the mdb files level, HR can access A,
no one else is allowed to open this database.
My question is:
Can I create a link table in the B database from A database, which
will include only some of the columns from that table, and without
allowing anyone to open A?

If not, what is the closest solution?

best regards,
Kamil

 

[tedmi]

Access does implement user-level security, whereby an administrator can limit
a user's right to use certain objects. Thus, users from HR could be given
rights to use queries which display all of the columns of the HR database;
other users only to queries in the Admin DB which display non-confidential
data from the HR DB.
HOWEVER, Access security is not very robust. For this type of application,
you really need SQL Server for the HR database. The Admin DB could be Access,
with queries that display only non-confidential data from SQL Server.

 

[Kamil]

Access does implement user-level security, whereby an administrator can limit
a user's right to use certain objects. Thus, users from HR could be given
rights to use queries which display all of the columns of the HR database;
other users only to queries in the Admin DB which display non-confidential
data from the HR DB.
HOWEVER, Access security is not very robust. For this type of application,
you really need SQL Server for the HR database. The Admin DB could be Access,
with queries that display only non-confidential data from SQL Server.

I'm thinking about a workaround. A privileged HR user can export the
necessary data to a table C, which will have the same privileges like
B.
As it is only hundreds of records, it can be done everytime the
database is closed by VBA. What do you think about it?