C
CB
Hi all,
My database is almost ready to be distributed to my users so I’m working on
tightening up the security. Yesterday I found information SOMEWHERE on these
newsgroups (or related link??) regarding removing permissions to all tables
and queries and changing queries properties to run with owner’s permissions.
For the life of me I can’t find that info today (I’ve spent a couple hours
searching so far!); hence, my posting.
I’ve tried setting the following permissions for my Read-Only Users:
- current database as open/run
- tables: (1) “Switchboard items†as read data, read design
(2) “Database problems†as read data, read design, insert data
- queries: zero permissions but as mentioned above permissions property set
to Owner’s
- forms: open/run
- reports: open/run
- macros: open/run
I tried testing this by logging in as one of my users. From the switchboard,
I was able to open the form that allows users to report database
problems/issues. However, every other switchboard button that would launch
other forms or reports results in the error “There was an error executing the
command."
What am I missing? I feel perhaps I might have misinterpreted something but
of course I can’t find the information that I found yesterday.
Thanks for any and all help!
Chris
My database is almost ready to be distributed to my users so I’m working on
tightening up the security. Yesterday I found information SOMEWHERE on these
newsgroups (or related link??) regarding removing permissions to all tables
and queries and changing queries properties to run with owner’s permissions.
For the life of me I can’t find that info today (I’ve spent a couple hours
searching so far!); hence, my posting.
I’ve tried setting the following permissions for my Read-Only Users:
- current database as open/run
- tables: (1) “Switchboard items†as read data, read design
(2) “Database problems†as read data, read design, insert data
- queries: zero permissions but as mentioned above permissions property set
to Owner’s
- forms: open/run
- reports: open/run
- macros: open/run
I tried testing this by logging in as one of my users. From the switchboard,
I was able to open the form that allows users to report database
problems/issues. However, every other switchboard button that would launch
other forms or reports results in the error “There was an error executing the
command."
What am I missing? I feel perhaps I might have misinterpreted something but
of course I can’t find the information that I found yesterday.
Thanks for any and all help!
Chris