security

  • Thread starter Thread starter x
  • Start date Start date
X

x

hi
i have made a small database for my logbook. i am being asked by my
colleagues that i should give them the file as they see it to be
helpful. now the problem is that when i use "user level security
wizard" and create a user with limited privilages and place it in say
"full data users" or "new data users" or "update data users" groups.
when i test the file everything works fine execpt for a make table
query ( i have five to six queries which run togethar through one
"update all" button, out of these two are make table queries. these two
won't work whatever i do. update all button works fine when i run it
using admin user. The only group where, when i place the user this
button works is "full permissions users".
i want to give limited permissions to the users and don't want them to
view or edit the structure of the db. (i know about the startup option
but there are some users who know the shift key function) someone told
me that there is a small piece of code which can help in this regard
but i have found that it is meant for access 2000 only where as i am
using ms access 2003. so
HELP
thanx in advance
bye and tc
 
Hi x.

x said:
hi
i have made a small database for my logbook. i am being asked
by my colleagues that i should give them the file as they see it to
be helpful. now the problem is that when i use "user level security
wizard" and create a user with limited privilages and place it in say
"full data users" or "new data users" or "update data users" groups.
when i test the file everything works fine execpt for a make table
query ( i have five to six queries which run togethar through one
"update all" button, out of these two are make table queries. these
two won't work whatever i do. update all button works fine when i
run it using admin user. The only group where, when i place the
user this button works is "full permissions users". i want to give
limited permissions to the users and don't want them to view or
edit the structure of the db. (i know about the startup option but
there are some users who know the shift key function) someone
told me that there is a small piece of code which can help in this
regard but i have found that it is meant for access 2000 only where
as i am using ms access 2003. so HELP
Click to expand...

I guess that that piece of code grants the desired group the privilege
to create new objects in the tables container of the database.
Why should this not work in Access 2003?
(You probably a reference to the DAO library for executing that code)
 
Back
Top