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
On Nov 9, 8:00 am, fred...@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
One solution which may suffice is to keep all of your non-key fields
encrypted and then unencrypt them when they are needed with a simple
on-th-fly encrypt/decrypt function. Then create an .mde file, which
can protect your code, but not your data. You would still want the
searchable fields to be unencrypted. If your encryption program
combines character substition and scrambling, then you would be well
protected.
news:1194616808.643261.112680@y27g2000pre.googlegroups.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.