Security w/ Links & Table Import

[Bret]

Please,
Presently, 20 users are given read/write access to a
shared folder which holds my backend mdb. This will not
change.
The frontend allows user to view THEIR data only through
forms and tables. I do this base on their login and
queries run based on their name.

However, one of the users is able to create a new Access
mdb from scratch and import tables and link tables to the
backend thus being able to VIEW ALL DATA. Is there a way
thru Access security or code to deter this?

thank you!

 

[Scott McDaniel]

The behaviour you describe is expected and normal. If you haven't secured
the database properly and removed access to your tables (and granted access
to data ONLY through RWOP queries), then you'll never be able to stop people
from linking to your tables.

Download and read-read-read the MS Access Security FAQ. Try securing a copy
of your database. Follow the steps exactly as they are described in the
document.

http://support.microsoft.com/default.aspx?scid=/support/access/content/secfaq.asp