D
dena
I converted a 97 database to 2002 and granted permissions
to an admin along with 2 users. My application ran fine
under 97 and also runs fine as long as I am logged in as
the admin user. I get the error message "Run-time error
3033: You don't have permissions to use the MSysTables
object" when I log in as an ordinary user and try to run a
piece of code that is creating a query definition.
The users have all permissions except Administer for all
tables & queries and also have open/run for the database,
open/run & read design for the form and read design for
the report & macro. I tried granting the users all rights
to all objects and it didn't make any difference. I then
tried adding the users to the admin's group and the error
went away. Does anyone have any idea what is causing my
error and how to make it go away without having to add the
users to the admins group? Thanks so much.
to an admin along with 2 users. My application ran fine
under 97 and also runs fine as long as I am logged in as
the admin user. I get the error message "Run-time error
3033: You don't have permissions to use the MSysTables
object" when I log in as an ordinary user and try to run a
piece of code that is creating a query definition.
The users have all permissions except Administer for all
tables & queries and also have open/run for the database,
open/run & read design for the form and read design for
the report & macro. I tried granting the users all rights
to all objects and it didn't make any difference. I then
tried adding the users to the admin's group and the error
went away. Does anyone have any idea what is causing my
error and how to make it go away without having to add the
users to the admins group? Thanks so much.