Hiding the design of database objects, while being able to EDIT da

[Kim]

Hi

Is there a way to create a User Role (in the Security Permissions)
for someone who can
Enter New Records
Edit Exisitng Records
Delete Existing Records (this is not as important)

WITHOUT them being able to see the actual design of the tables (ether in
Tables or Queries)?

I've enabled the security and tried playing with the permissions but I 'm
stumped. Hiding the objects, doesn't help as someone can just turn the
option back on. I'm thinking that I need to set the start up menu, disable
the SHIFT key shortcut and then Hide the objects?

Is there something I'm missing?

Thanks
kim

 

[Scott McDaniel]

Check the MS Security FAQ ... you can allow users to manipulate data through
RWOP (Run With Owner Permissions) queries, and then remove permissions to
the tables.

http://support.microsoft.com/default.aspx?scid=/support/access/content/secfaq.asp

There's a section there which describes how to do this.

 

[TC]

Not really. It doesn't make sense to ask for a user to be able to add
or dedit data, but not be able to see the design of the underlying
table or query.

Here is what I said about this recently:

http://groups.google.com/group/microsoft.public.access.security/msg/711026dfed83ac5c

HTH,
TC