InsertOnly capability?

  • Thread starter Thread starter Anno v. Heimburg
  • Start date Start date
A

Anno v. Heimburg

Hello,

does anybody have an idea how to implement an InsertOnly permission with
Access(2000/2002)? I need to have a table where a user can insert a new
record, but not view any other record (being able to view the row he
created would be acceptable, but not necessary).

It seems that that is not possible with the built-in Access permission,
because the "Insert" capability implies the "Read" capability. If I'm
wrong, I'ld be glad if you tell me.

Otherwise, is it possible to create an equivalent security level with vba?
If yes, I'ld appreciate some pointers. I guess I'll have to disable the
shift key, hide the DB window and do all data access via vba and forms.

Thanks,
Anno
 
Anno v. Heimburg said:
Hello,

does anybody have an idea how to implement an InsertOnly permission with
Access(2000/2002)? I need to have a table where a user can insert a new
record, but not view any other record (being able to view the row he
created would be acceptable, but not necessary).

It seems that that is not possible with the built-in Access permission,
because the "Insert" capability implies the "Read" capability. If I'm
wrong, I'ld be glad if you tell me.

Otherwise, is it possible to create an equivalent security level with vba?
If yes, I'ld appreciate some pointers. I guess I'll have to disable the
shift key, hide the DB window and do all data access via vba and forms.
Click to expand...
This is not a security issue as such. Base a form on your table/query and
set the "Data Entry" property to "Yes". Users can create new records but
existing ones are not displayed.

Regards,
Keith.
www.keithwilby.com
 
Say the user /can not/ see the record he entered.

What if he enters a new record, hits Save, and then realizes that he
mistyped an important field?

HTH,
TC
 
TC said:
Say the user /can not/ see the record he entered.

What if he enters a new record, hits Save, and then realizes that he
mistyped an important field?
Click to expand...
He goes to the OP and gets him to change it ;-)
 
Back
Top