InsertOnly capability?

[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

 

[Keith]

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.

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

 

[TC]

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

 

[Keith]

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?

He goes to the OP and gets him to change it ;-)

 

[Anno v. Heimburg]

He goes to the OP and gets him to change it ;-)

Actually, yes, that's an acceptable limitation.

Don't ask me, ask my client...

Anno.

 

[Keith]

Actually, yes, that's an acceptable limitation.

Don't ask me, ask my client...

Don't worry, we've all been there!