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

<fredloh@gmail.comwrote in message
news:1194616808.643261.112680@y27g2000pre.googlegr oups.com...

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
>

If your secured database (Access security) can be easily linked and opened,
security may have been improperly applied. Search this group and the
Microsoft site for information on Appling Access security.

On Fri, 09 Nov 2007 14:00:08 -0000, fredloh@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.