Access 2003 Security permission problem

[isetea]

Hi,
I have a database, which contains linked tables to another database. The information held in the tables are mostly open for every permitted user but some of the table informations are restricted to a few user only. To manage all of this different permissions I created a workgroup, changed all the necessary things to become an administrator and run the security wizard to secure my database. Finally I want to give every single group the access it belongs to. And there is my problem.
I have a form which has a VBA code underlying which selects data from a table and two queries and where the user can set individual criterias. For me as an admin user this form works perfect. When I log on as a user I can't find out how to set the permissions not to receive the error message: "You do not have the necessary permission to use the 'MSys Table' object...." The user should not be an admin user and I already set the modify, update, delete, read, read design permission to the group. Nothing helps.
Please if anybody has an idea what I can try I really would appreaciate this help!
Thanks very much

 

[FuzMic]

Hi there
2 possible reasons
1) the database object type (not the table) is not set to open/run
2) your VBA query codes involve queries that 2a) don't have 'run permission' set to 'Owners rights' 2b) query on tables that ordinary user has no right to delete / add / modify
Not sure the leads will solve yr problem as MsHelp is a maze, I too am struggling with security problems.
Cheers and best of luck!