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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kim - 29 Aug 2005 23:26 GMT

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

Reply to this Message

Scott McDaniel - 30 Aug 2005 03:11 GMT

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=%2Fsupport%2Faccess%2Fcontent%2Fs
ecfaq.asp

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

Signature

Scott McDaniel
InfoTrakker Software

> Hi
>
[quoted text clipped - 17 lines]
> Thanks
> kim

Reply to this Message

TC - 30 Aug 2005 04:29 GMT

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

Reply to this Message