Workgroup Permissions

[Ryan]

I have a database with its own workgroup file for setting
permissions. I would like users to be able to enter data
into the table, but not view the table when they finish.
Currently I have the table hidden, but I am looking for a
better way to secure the data. Is it possible to setup
users with no read or write access initially, give them
access to write their data to the table, then take away
read permissions after they make their entry. A sub in
VBA for when the form closes perhaps? Is this a good
solution, or is there a better, easier way? Thanks in
advance.

Ryan

 

[Adrian Jansen]

You can set the permissions of the group they are in to "New data only",
allowing them to add data, but not view/edit it. As long as you do all your
entries through forms, you can set the queries to "With owner permission",
and then remove their permissions from the tables entirely. This is better
than simply hiding the tables, which anybody can unhide. All this assumes
you have the database properly secured of course.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control