lock tables

[fredloh]

it is easy to go to the database window to double click on a table and
open it. it is also possible to import or link tables of a secured
database and open up the tables in a new database.

is there any way i can secure (lock or hide) access tables so nobody
can open it via the database window or via import and link?

TIA

 

[Jeff Boyce]

If you "give" your users access to the database window, no.

If you button down your application, create forms and reports, and have your
users using those, you can discourage the casual lookie-lou.

If you add Access security (a strenuous bit of exercise, not for the
faint-hearted), you can keep the casual lookie-lou's out, but the serious
hacker will find a way in.

Or if you MUST (federal regulation, ...) prevent access to the underlying
tables, put them in a more secure, more robust, more controlled back-end ...
e.g., SQL-Server.

Good luck!

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/