By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,985 Members | 2,920 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,985 IT Pros & Developers. It's quick & easy.

Hi, How do I remove Users permission through code?

P: 44
How do I remove/ revoke Users permission to an object i.e. Table through code in ms access? Thanks for all your help. Regards
Mar 1 '10 #1
Share this Question
Share on Google+
1 Reply


P: 44
Basically I have built ms access front end in which tables are linked with sql server through dsn less connection. I have used ms access security feature user and group accounts. Default user has no permission. Tables are append/linked through a code when a user login. When user exits I used delete object macro to delete all linked tables. The problem is when a user login to all tables are linked but by default a user e.g. xyz gets full rights to the linked tables directly i.e. insert, del, update etc. Here I need a code which I use to revoke user permission. Please help. Thanks
Mar 2 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.