C
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
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