Hi,
maybe I should try again. It seems there are a few user of this forum with enough knowledge to help me out of my problem. Unfortunately I got no reply to my first post yet. I'm still in pain with Access Security permission and forms running VBA code.
Anybody out there with an idea, please!!! I can post my code if this helps...
I have a form which has a VBA code underlying which selects data from tables and queries and where the user can set individual criterias. For me as an admin this form works perfect. When I log on as a user and run the select query directly it works perfect. If I use my form with the VBA code running the query I got the 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.
What's wrong with VBA code selects and security?
maybe I should try again. It seems there are a few user of this forum with enough knowledge to help me out of my problem. Unfortunately I got no reply to my first post yet. I'm still in pain with Access Security permission and forms running VBA code.
Anybody out there with an idea, please!!! I can post my code if this helps...
I have a form which has a VBA code underlying which selects data from tables and queries and where the user can set individual criterias. For me as an admin this form works perfect. When I log on as a user and run the select query directly it works perfect. If I use my form with the VBA code running the query I got the 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.
What's wrong with VBA code selects and security?
