Don't allow view of tables

[Cathy]

I have a database where users fill forms and the data is
stored in tables. The users need read/write access to
update the tables. The stored information is considered
confidential so we don't want users to be able to view the
tables. We have users with multiple levels of Access
expertice.

I tried hiding the database, but users used F11 to unhide
the tables. (Can I disable or redefine F11?)

I tried hiding the tables, but they found ways to get
around that too...

I tried taking their permission to view away, but that took
their ablilty to read/write.

An .MDE doesn't seem to be the answer because I'm missing
other functionality I need to be able to perform on the tables.

I haven't tried splitting the database yet, but I
understand they can still view the tables...

What can you suggest?
Thanks,
Cathy

 

[Joan Wild]

You can use RWOP queries. Create queries for all data interaction
(forms/reports), and set the run permissions to Owner (it's in the queries'
property box).

Your users will then not require *any* permission on the tables. You'll
need to give them read/update permission on the query.

You can disable the F11 key, by setting the options under Tools, Startup -
where you can hide the db window, set default menubar, and other options.

It sounds as though you have mischievous users - perhaps management could
take some action here.

It won't be long before they find out they can hold the shift key down and
bypass the settings you set in Tools, Startup. You can disable the shiftkey
bypass - see
http://www.mvps.org/access/modules/mdl0011.htm
and
http://www.mvps.org/access/general/gen0040.htm