On Fri, 09 Nov 2007 14:00:08 -0000,
fr*****@gmail.com wrote:
>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
You can hide your tables from view by adding usys to the file name,
A table called 'produce' for example will hide itself if you rename it
to usysproduce.
Just ensure that under the tools menu, the system objects check box is
clear on the veil tab and the won't be seen.
Any links you may have to the renamed tables will also have to be
updated.