How do I remove/ revoke Users permission to an object i.e. Table through code in ms access? Thanks for all your help. Regards
-
-
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
Comment